Replies

Try holding down the Shift key and press Delete (permanent delete)…

The reason I think it is user-based is that it is not occurring on every machine… the point that it only happens on a few suggests it may be a more of a desktop issue?

By any chance is there a version difference between the offices – i.e., your office is Word 2007 and the receiving office is Word 2003? If so, you may need them to install the Office 2007 Compatibility Pack.

Another troubleshooting item… the file maybe on its way to corruption (many tables – as you mentioned eeeechh)… Open Word with NO document. Choose File, Open and navigate to the file (ensure it is on a network drive/local machine). Select the file and then choose the drop-down with the Open command and select Open and Repair. If Microsoft attempts to repair the file, I would suggest it be reformatted from scratch… there is probably a corrupt table somewhere (and that is very hard to diagnose in Word). Try copying all text, EXCEPT the last paragraph marker, to a new blank document first. Save and try the Open and Repair again… if still repairing, recreate the document (this will suck!)

Hope this helped…

I have converted a few companies from Groupwise to Outlook – unfortunately the two products do not work the same. In order for you to accomplish the sharing of contacts universally, you will have to purchase an add-on program, similar to: Sharing Contacts Software – there are probably others – I have not experienced any of these applications – just worked with what Outlook provides. Good luck…

Just a thought… sometimes users change options in Outlook not realizing the consequence… check this link out from MS MS Plain Text Option

When an Excel spreadsheet is linked to a Word document it is usually defined as a field. To check this out, select the excel link and press Alt+F9 – you will see the field that is pointing the spreadsheet back to the Excel file – it appears similar to { LINK Excel.Sheet.8 “C:\My Documents\Excel\Budget2009.xls” “SheetName!R9C1:R25C2” a p}. You can very easily strip these fields to be ’embedded’ tables instead of linked.

For your purposes, I would first copy the document (so that you can still use the sheet for future use), then select all (Ctrl+A) and strip the fields in the document to ’embedded’ tables (Ctrl+Shift+F9).

Also, you can break links through Edit, Links (towards bottom of menu) and select all the links from the dialog and choose Break Links command.

Whichever way you find easiest. Hope this helps… trish

I was thinking of putting code like this in AutoExec. This checks whether one of your unique styles exists in Normal.Dot, if not then you can call the procedure you already have to copy the styles.

Code:

	 Sub checknormal()
	  Dim doc As Document
	  Dim sty As Style
	  Dim blFound As Boolean
	  Const strCheck As String = "Private Style"   ' Name of a style in customized normal.dot
	  
		  blFound = False
		  On Error GoTo ErrorHandler
		  Set doc = Application.NormalTemplate.OpenAsDocument
				
		  For Each sty In doc.Styles
			  If sty.NameLocal = strCheck Then 
				  blFound = True
				  Exit For
			 End If
		 Next sty
				
		  ' If not blFound then  ' call the procedure that updates normal.dot here
				
	  ErrorHandlerExit:
		On Error GoTo 0
		doc.Close SaveChanges:=False
		Set doc = Nothing
		Exit Sub
		
	ErrorHandler:
		MsgBox "Error No: " & Err.Number & "; Description: " & Err.Description
		Resume ErrorHandlerExit
	
	End Sub

Thanx so much for this suggestion Stuart… I will ask the client if this will be suitable… have a great day… trish

I would use the application settings for your file paths

Code:

With Application
 .OrganizerCopy Source:= .StartupPath & "TLMUser.dot", _
	Destination:= Options.DefaultFilePath(wdUserTemplatePath) & "Normal.dot", _
	Name:="Normal", Object:=wdOrganizerObjectStyles
End With

Your other code would work equally as well and could be shortened to

Code:

With ActiveDocument
  .UpdateStylesOnOpen = False
  .AttachedTemplate = "TLMUser.dot"
  .RefreshStyles
End With

Hi Andrew, thanx very much for the help with the code. In case other’s view this article, the OrganizerCopy code requires (wdUserTemplatesPath) – the ‘s’ was missing after template.

I changed the second set of code to your shortened method and now I’m receiving an Error 438 – when I debug it’s stopping on .RefreshStyles – I can’t find anything on this code and Word but did find references to Excel. **Update** My memory came back for a moment and I remembered UpdateStyles… this worked. Once again, anyone referring please use .UpdateStyles instead of .RefreshStyles.

Also, this code is still inserting the TLMUser.dot toolbar into the active document – very unsure why this is happening ??? Any ideas. **Update** As I plug away at this, I finally figured out that it was copying styles from a TLMUser.dot that was temporarily being stored under the Templates folder. I have deleted this old file. I would have thought that .AttachedTemplate would have referenced the StartUp Folder – any quick thoughts on how I should change this line to the Startup path?

Also, one last thing… is it possible to loop through the OrganizerCopy code at all? As I am a contractor, I may not be around in the future to add a new style that is required.

I will be showing a presentation in June and we have had so many people sign up, that they want to use 2 projectors, since it will be hard for everyone to see the main screen. The hall we are using is long and narrow, and it’s a luncheon, so they don’e want everyone to have to move to see it.

I can set up the laptop so that it is about 25 feet from each projector, maybe a little over. I have one 25 feet cable that connects the laptop to the projector, so I could move the laptop closer to one projector and get a longer cable for the the other.

I know that I will need a splitter and I’m assuming that I will have to do something to boost the signal coming out of the laptop. I was wondering if anyone has done this and is it worth pursuing. If it turns out one of the images, or both, are bad, I would just as soon only show it on one screen and make everyone move. Anyone have any experience with this type of thing that they could share? Thanks.

Not sure if there are other meeting rooms and other resources that you have available – you could use WebEx in a completely different room, which would need a computer, projector and polycom or handsfree telephone… just a thought??

I have recently combined my archive.pst, archive1.pst and archive2.pst files into 2 pst files: ArchiveFolders1 and ArchiveFolders2. Yesterday, when Outlook went to perform its routine autocarchive, I received an error message and the following in the log:

“Error while archiving folder “Inbox” in store “Personal Folders”. Errors have been detected in the file C:…Outlook.pst. Quit Outlook and all mail-enabled applications, and then use the Inbox repair tool (Scanpst.exe) to diagnose and repair errors in the file. For more information about the Inbox repair tool, see Help.”

The first thing I did was to check that my folders were programed to archive to Archivefolders2. They were not. They were set to archive to the old archive2.pst, which no longer exists. Then I tried to archive again, but received the same error message.

Then I tried to look for Scanpst.exe in my C drive and did not find it. I also tried looking for it in the My Computer folder, but it was not there, either.

Does anyone know what the problem can be and how to access Scanpst.exe?

Regards,

JMT

If Hans’ solution did not work, the pst file may be Oversized… MS quotes the exact same error message you received… if this is the case, then you may want to follow instructions for Oversize PST:

Oversized PST Crop Tool

Be aware of the following when using the crop tool

[*]You must have 2 GB of free hard disk space (to make a copy of the .pst file).

[*]The utility truncates the .pst file to under 2 GB. To have enough working space, truncate the file between 20 to 25 megabytes (MB) less than the 2 GB limit. The truncated data is removed from the new copy, which means some messages are missing from the recovered copy.

For future tasks performed on psts, you may want to use the Compact Now function after moving/removing items. As my rule of thumb, after I archive items from one pst to another, I always compact the .pst that the files were moved/removed from. Outlook does not reduce the size of the .pst after files have been moved/removed – using the Compact Now command will ‘defrag’ the file and size it accordingly.

See the following: How to Compact a PST in Outlook

Trish,

Hopefully someone here has implemented something like what you’re trying to achieve, and can give specific code advice for this problem.

But something that doesn’t seem clear here: if your client’s IT department forbids your providing a customized Normal.dot, why are they permitting you to put a global template in the startup directory, that contains code that customizes Normal.dot?! – isn’t that doing the same thing they don’t want you to do, just through much more complicated and unreliable means? Wouldn’t it be much more reliable to avoid the complicated code, and just permit you to do the customizations you want to Normal.dot, manually?

Another angle on this is: why not just leave Normal.dot alone, and produce an alternative “Blank” or “House Style” template that would be the default for all new documents created at the client? This could contain the custom styles, autotexts, etc., while leaving Normal.dot untouched.

Gary

The company wants to decrease the amount of support required for this one department. The helpdesk tends to delete normal.dot files for ‘any’ issues word may be having… it’s crazy… most of the time it’s not the normal.dot, but a corrupt document, lack of knowledge of the software, or the user changing options. Since this customization will only be distributed to approx 60 people out of >1000 in the office, and at the rate the helpdesk deletes the normal.dot, it would would be very hard for everyone to remember that these 60 individuals have a ‘different’ normal.dot than the rest of the company. I would love to be able to distribute the normal.dot and not have to figure this out…

I did think about creating a template that would include all the customization that they could base all new documents on; however, I’m pretty sure this would be too many ‘steps’ to get the customization and most people would not even bother.

So here I am broken hearted… trying to figure out a good automated alternative. Thanx for making suggestions and clarifying the reasoning. Have a great day!

You could automate this even further by having code in User.Dot that checks to see if the required styles are in Normal.dot, and initiates the copy if needed. Then you wouldn’t need the toolbar button and the training.

I’m assuming you are suggesting that I put some code into an AutoOpen macro? Could you give me a little more information on how to perform this? Thanx so much… trish

I would use the application settings for your file paths

Code:

With Application
 .OrganizerCopy Source:= .StartupPath & "TLMUser.dot", _
	Destination:= Options.DefaultFilePath(wdUserTemplatePath) & "Normal.dot", _
	Name:="Normal", Object:=wdOrganizerObjectStyles
End With

Your other code would work equally as well and could be shortened to

Code:

With ActiveDocument
  .UpdateStylesOnOpen = False
  .AttachedTemplate = "TLMUser.dot"
  .RefreshStyles
End With

Thanx for the help in better stating the code in both cases. Is there a way to loop the OrganizerCopy command to collect ALL styles in the user.dot so that I do not have to reference each style/autotext – more may be added in the future.

Also, with the second code… is there a way to make this code work updating the Normal.dot?

Thanx in advance for your assistance…

Thanx Hans… I’ll find out if the reg key is being modified… you’re the best… trish

Hi Hans… I have a quick question. I’ve been contracting with the same company for 5 years and for most of my time here there is a problem with picture placeholder which I cannot resolve. For some unknown and infrequent reason, the Picture Placeholder option turns ‘on’. The user is not changing this option – this happens to me on a regular basis too… but it is not happening to everyone (3000+ users). Do you have any ideas on why this phenomenon is happening? Could it be the result of the normal.dot being deleted or perhaps a MS update… Thanx in advance… trish