I have a word doc setup to link to variables in EPDM. I have put in the AutoOpen Macro per the admin guide; but when the doc is opened it doesn't update the items; but I can click on them and manually update each field. Any ideas as to what would cause the macro to not update the fields on opening
thank you
Jeff,
I've never had any issues with this type of macro itself.....on my machine, but on other machines the macro doesn't even appear inside the document.
I have an ECR.doc in a vault folder, and a template to pull ECR.doc for all new ECRs. The macro works great for me, but I've always had trouble distributing it.
Any tips?
Perhaps they have their macro security set too high? On the highest setting macros are stripped out.
on this 2nd machine, the trust settings are to enable all macros. If I look on the developer tab, no macros appear in the document.
Jeff,
I had to save the ECR as a macro-enabled file, a docm.
So once I set the output file to also be a docm, and updated all my variable attributes to include docm it worked like a champ.
Thanks!
Update Fields also in Footer and Header: Sub AutoOpen()
Dim aStory As Range
Dim aField As Field
Dim aSection As Section
Dim aHeaderFooter As HeaderFooter
For Each aStory In ActiveDocument.StoryRanges
For Each aField In aStory.Fields
aField.Update
Next aField
Next aStory
For Each aSection In ActiveDocument.Sections
For Each aHeaderFooter In aSection.Headers
Set aStory = aHeaderFooter.Range
For Each aField In aStory.Fields
aField.Update
Next aField
Next aHeaderFooter
For Each aHeaderFooter In aSection.Footers
Set aStory = aHeaderFooter.Range
For Each aField In aStory.Fields
aField.Update
Next aField
Next aHeaderFooter
Next aSection
End Sub
Open MS Word
Go to File > Options
Trust Center > Trust Center Settings
Trusted Locations > Add New Location
Path: Select your EPDM Root Folder
Check - Subfolders of this location are aslo trusted
GeirDa
Thanks, I'll check that out, but that would require setting that on every computer using PDM. For now the .docm is working well for me.
You can distribute registry settings to users:
We set this with our installation. The attached batch file is called during the install.
Yes, very nice
The admin guide's example will not automatically run upon open. It is simply a macro that you have to manually run. If you want the code to run automatically, you need to put the code in the document's Open Event.
Ensure the you have selected "Document" and "Open", causing the actual routine's name to be "Document_Open"
I've written more on this topic here. http://www.3dvision.com/wordpress/index.php/2010/10/14/auto-update-word-fields/