Looks like I finally found a different approach, updating fields on document save not on open. This works for me on Office 2013. The document open codes seem to have a problem with 2013. Probably an update would fix, but since I can't install updates I was stuck.Credits to this page (user Bond): httRead more
Looks like I finally found a different approach, updating fields on document save not on open. This works for me on Office 2013. The document open codes seem to have a problem with 2013. Probably an update would fix, but since I can’t install updates I was stuck.
I put the following codes into Normal.dotm – ThisDocument, so they are available in any document:
Dim WithEvents TheApp As Word.Application
Private Sub Document_Open()
Set TheApp = ThisDocument.Application
End Sub
Private Sub TheApp_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)
Doc.Fields.Update
End Sub
Now while the document opened still with numpages 2 instead of 7, when I clicked Save numpages changed to 7 which is the correct value.
Can’t seem to be able to mark this as solved myself, so if someone with powers would do that it would be great. Thanks.
One solution to this problem is to open a pdf document, click View: Show Thumbnails, and then drag all of the annotaed documents into the thumbnail bar. Next, simply print the entire document as a pdf. All of the annotations will now show in any document. This solution will be useful for those who hRead more
One solution to this problem is to open a pdf document, click View: Show Thumbnails, and then drag all of the annotaed documents into the thumbnail bar. Next, simply print the entire document as a pdf. All of the annotations will now show in any document. This solution will be useful for those who have annotated many documents and want a single, permanently annotated, single page document.
I have the ORIGINAL UKINFO disc as by the original maker NOT 192.com or the others that followed. This contains ALL the uk addresses and ALL the Phone numbers. All searchable and reverse search IE tel no. to obtain address. This disc was purchased by myself BEFORE British Telecom (pre 192.com ) threRead more
I have the ORIGINAL UKINFO disc as by the original maker NOT 192.com or the others that followed. This contains ALL the uk addresses and ALL the Phone numbers. All searchable and reverse search IE tel no. to obtain address. This disc was purchased by myself BEFORE British Telecom (pre 192.com ) threatened the maker with court and paid them off to stop making the discs……..
The rest is history.
I also have over the years purchased various other UKINFO ‘s but none have the same unrestricted access to both name and tel numbers (those days EVERYONES number was listed – yes most have altered the std codes (added a bit) but essentially most people keep their original home numbers – sometimes even if they move.
I keep all my discs as images for the very reason that the poster above has said…His disc is scratched and does not work…If you have UKINFO or any disc like that then you should protect your investment -spelt RIPOFF- (as per the price charged) my first disc cost £20! and was the original.
A very long shot (actually two); both of which I have found to produce a similar effect to that which you describe. Check the date on the problem computer; that is not set in the future. I had one occasion where that had happened - the date had been set (somehow) to a date in the near future. OutlooRead more
A very long shot (actually two); both of which I have found to produce a similar effect to that which you describe.
Check the date on the problem computer; that is not set in the future. I had one occasion where that had happened – the date had been set (somehow) to a date in the near future. Outlook canto send mail back in time…
Some anti-virus utilities can/will block out bound mail; Avast (is one that) will on some versions of windows (and Mac OS) and with some versions of Outlook block outbound mail.
Temporarily disable email screening… if the option exists in your anti-virus utility; and see if that resolves the problem.
Also (a third long shot) check firewall settings?
Perhaps use a working system as a model for the problem one; and compare settings various between the two systems?
Okay - so we need to see how the access table is formatted. The field for the translation must be Numerical. Can you change the Access table?Also - is the Pivot done in Access or are you importing the tables into Excel? never mind - I just saw your first line of your first post.But we should look atRead more
Okay – so we need to see how the access table is formatted. The field for the translation must be Numerical. Can you change the Access table?
Also – is the Pivot done in Access or are you importing the tables into Excel? never mind – I just saw your first line of your first post.
But we should look at how you are getting the information from Access to Excel.
You are correct in your assumption that the CF font color is not the same as the Font.ColorIndex. A CF Fill color is not the same as the Interior.ColorIndex either. Therefore, you cannot "test" a cell via VBA for those colors.If you want to find cells that have been Conditionally Formatted, you basiRead more
You are correct in your assumption that the CF font color is not the same as the Font.ColorIndex. A CF Fill color is not the same as the Interior.ColorIndex either. Therefore, you cannot “test” a cell via VBA for those colors.
If you want to find cells that have been Conditionally Formatted, you basically have to search for cells that meet the criteria that set the CF. VBA can set CF and clear CF, but it can’t find CF’d cells by searching for CF’d formats.
Now, in your case, you appear to have an option. Replace this…
' Delete text of white color in columns A and B ----------------------------- NOT WORKING
Dim rng As Range
Set rng = [B2:B279]
For Each Cell In rng
If Cell.Font.ColorIndex = 2 Then
Cell.ClearContents
End If
Next Cell
…with this, and both of your requirements will be met (for Column B, at least)
'Delete duplicate entries, Apply Red fill to Row of remaining entry
For rw = 279 To 2 Step -1
If Cells(rw, 2) = Cells(rw - 1, 2) Then
Cells(rw, 2).ClearContents
Else: Cells(rw, 2).EntireRow.Interior.ColorIndex = 3
End If
Next
I'm not sure if this is what you are looking for, so try it and let us know: =IF(COUNTA(L7,N7,O7)>0,IF(SUM(L7,N7,O7)<80,80-SUM(L7,N7,O7),""),"") This will return a blank cell unless there is a value in any one or more of the cells L7,N7 and O7. IF(COUNTA(...) If there is aRead more
I’m not sure if this is what you are looking for, so try it and let us know:
=IF(COUNTA(L7,N7,O7)>0,IF(SUM(L7,N7,O7)<80,80-SUM(L7,N7,O7),""),"")
This will return a blank cell unless there is a value in any one or more of the cells L7,N7 and O7. IF(COUNTA(…)
If there is a value in any of those cells and the SUM is =80, it will return a blank cell. (No more points needed)
The one thing that is not clear to me is whether a student can get more than the MAX points for any one of those criteria.
For example, a 40 in Participation, a 40 on the Tues exam and a 5 on the Thur exam would give them 85 points, but it wouldn’t meet the criteria listed. Are those grades possible or are the MAX values you mention the MAX that will be awarded?
Do you see the difference? Whether or not my formula will work depends on the answer to that question.
Highlight the cell or group of cells, right click, go to FORMAT CELLS, in NUMBERS tab click TEXT tab. Anyththing entered in cell/s, even nmbers, will be treated as text.
Highlight the cell or group of cells, right click, go to FORMAT CELLS, in NUMBERS tab click TEXT tab. Anyththing entered in cell/s, even nmbers, will be treated as text.
The process for creating dependent drop downs requires the use of the INDIRECT function and Named Ranges.Instead of detailing all of the steps in this response, I suggest that you review the instructions found here:http://www.contextures.com/xlDatava...You can also Google "Dependent Dropdown List" fRead more
The process for creating dependent drop downs requires the use of the INDIRECT function and Named Ranges.
Instead of detailing all of the steps in this response, I suggest that you review the instructions found here:
Word VBA AutoOpen For Field Updating – Not Working
Looks like I finally found a different approach, updating fields on document save not on open. This works for me on Office 2013. The document open codes seem to have a problem with 2013. Probably an update would fix, but since I can't install updates I was stuck.Credits to this page (user Bond): httRead more
Credits to this page (user Bond): https://stackoverflow.com/questions…
I put the following codes into Normal.dotm – ThisDocument, so they are available in any document:
Dim WithEvents TheApp As Word.Application Private Sub Document_Open() Set TheApp = ThisDocument.Application End Sub Private Sub TheApp_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean) Doc.Fields.Update End SubNow while the document opened still with numpages 2 instead of 7, when I clicked Save numpages changed to 7 which is the correct value.
Can’t seem to be able to mark this as solved myself, so if someone with powers would do that it would be great. Thanks.
message edited by Mrrrr
Unreadable Comments In PDF Sent From IPhone Adobe Reader App
One solution to this problem is to open a pdf document, click View: Show Thumbnails, and then drag all of the annotaed documents into the thumbnail bar. Next, simply print the entire document as a pdf. All of the annotations will now show in any document. This solution will be useful for those who hRead more
More please check this thread.
https://discussions.apple.com/message/annotated-comments-can-not-read-in-pdf
UK Info Disc Wanted
I have the ORIGINAL UKINFO disc as by the original maker NOT 192.com or the others that followed. This contains ALL the uk addresses and ALL the Phone numbers. All searchable and reverse search IE tel no. to obtain address. This disc was purchased by myself BEFORE British Telecom (pre 192.com ) threRead more
I have the ORIGINAL UKINFO disc as by the original maker NOT 192.com or the others that followed. This contains ALL the uk addresses and ALL the Phone numbers. All searchable and reverse search IE tel no. to obtain address. This disc was purchased by myself BEFORE British Telecom (pre 192.com ) threatened the maker with court and paid them off to stop making the discs……..
The rest is history.
I also have over the years purchased various other UKINFO ‘s but none have the same unrestricted access to both name and tel numbers (those days EVERYONES number was listed – yes most have altered the std codes (added a bit) but essentially most people keep their original home numbers – sometimes even if they move.
I keep all my discs as images for the very reason that the poster above has said…His disc is scratched and does not work…If you have UKINFO or any disc like that then you should protect your investment -spelt RIPOFF- (as per the price charged) my first disc cost £20! and was the original.
See lessOutlook 2007 Server 530.5.7.1
A very long shot (actually two); both of which I have found to produce a similar effect to that which you describe. Check the date on the problem computer; that is not set in the future. I had one occasion where that had happened - the date had been set (somehow) to a date in the near future. OutlooRead more
A very long shot (actually two); both of which I have found to produce a similar effect to that which you describe.
Check the date on the problem computer; that is not set in the future. I had one occasion where that had happened – the date had been set (somehow) to a date in the near future. Outlook canto send mail back in time…
Some anti-virus utilities can/will block out bound mail; Avast (is one that) will on some versions of windows (and Mac OS) and with some versions of Outlook block outbound mail.
Temporarily disable email screening… if the option exists in your anti-virus utility; and see if that resolves the problem.
Also (a third long shot) check firewall settings?
Perhaps use a working system as a model for the problem one; and compare settings various between the two systems?
See lessMultiple Conditional Formatting For Pivot Tables
Okay - so we need to see how the access table is formatted. The field for the translation must be Numerical. Can you change the Access table?Also - is the Pivot done in Access or are you importing the tables into Excel? never mind - I just saw your first line of your first post.But we should look atRead more
Also – is the Pivot done in Access or are you importing the tables into Excel?never mind – I just saw your first line of your first post.
But we should look at how you are getting the information from Access to Excel.
Macro To Remove Some Text With Condition And Add Color Shade
You are correct in your assumption that the CF font color is not the same as the Font.ColorIndex. A CF Fill color is not the same as the Interior.ColorIndex either. Therefore, you cannot "test" a cell via VBA for those colors.If you want to find cells that have been Conditionally Formatted, you basiRead more
If you want to find cells that have been Conditionally Formatted, you basically have to search for cells that meet the criteria that set the CF. VBA can set CF and clear CF, but it can’t find CF’d cells by searching for CF’d formats.
Now, in your case, you appear to have an option. Replace this…
' Delete text of white color in columns A and B ----------------------------- NOT WORKING Dim rng As Range Set rng = [B2:B279] For Each Cell In rng If Cell.Font.ColorIndex = 2 Then Cell.ClearContents End If Next Cell…with this, and both of your requirements will be met (for Column B, at least)
How To Post Data or Code —> Click Here Before Posting Data or VBA Code
message edited by DerbyDad03
How To Remove ‘Recent Document History’ In Apache OpenOffice
It depends on which history you mean. Do you mean from windows which remembers the documents history or inside the program itself?
It depends on which history you mean. Do you mean from windows which remembers the documents history or inside the program itself?
See lessExcel Formula To Calculate Passing Grade
I'm not sure if this is what you are looking for, so try it and let us know: =IF(COUNTA(L7,N7,O7)>0,IF(SUM(L7,N7,O7)<80,80-SUM(L7,N7,O7),""),"") This will return a blank cell unless there is a value in any one or more of the cells L7,N7 and O7. IF(COUNTA(...) If there is aRead more
I’m not sure if this is what you are looking for, so try it and let us know:
=IF(COUNTA(L7,N7,O7)>0,IF(SUM(L7,N7,O7)<80,80-SUM(L7,N7,O7),""),"")
This will return a blank cell unless there is a value in any one or more of the cells L7,N7 and O7. IF(COUNTA(…)
If there is a value in any of those cells and the SUM is =80, it will return a blank cell. (No more points needed)
The one thing that is not clear to me is whether a student can get more than the MAX points for any one of those criteria.
For example, a 40 in Participation, a 40 on the Tues exam and a 5 on the Thur exam would give them 85 points, but it wouldn’t meet the criteria listed. Are those grades possible or are the MAX values you mention the MAX that will be awarded?
Do you see the difference? Whether or not my formula will work depends on the answer to that question.
See lessExcel Format Text Such As Aa-Aaa-Aa
Highlight the cell or group of cells, right click, go to FORMAT CELLS, in NUMBERS tab click TEXT tab. Anyththing entered in cell/s, even nmbers, will be treated as text.
Highlight the cell or group of cells, right click, go to FORMAT CELLS, in NUMBERS tab click TEXT tab. Anyththing entered in cell/s, even nmbers, will be treated as text.
See lessDependent Drop Down Menues With Numbers
The process for creating dependent drop downs requires the use of the INDIRECT function and Named Ranges.Instead of detailing all of the steps in this response, I suggest that you review the instructions found here:http://www.contextures.com/xlDatava...You can also Google "Dependent Dropdown List" fRead more
Instead of detailing all of the steps in this response, I suggest that you review the instructions found here:
http://www.contextures.com/xlDatava…
You can also Google “Dependent Dropdown List” for a lot more hits.
If you have any trouble setting these up, let us know.