Document_Open does not work in Word 2007 template

ukzrsuwy5p · #1 09-25-2019, 04:48 AM

For employees to work, I need to put some functionality into the Document_Open macro. I want to put this macro in a template (.dot) and place it on the network. Office 2007 is installed on most machines, and I'm testing on it. I create a document, insert the macro code, save it as a template (.dot). I use the following macro as a test:

Code:

Sub Document_Open()
MsgBox "ABC" 
End Sub

Next, I create a document (.doc) and change the document template on my created template. I allow the execution of macros, the macro work. I save and close the document, when I reopen the document and enable macros, our macro does not work. What the problem is I can’t understand. Thank!

Guessed · #2 09-25-2019, 03:49 PM

May be lost in translation.

Template should be saved as (.dotm). Document should be saved as (.docx). Which module is the Document_Open saved in?

ukzrsuwy5p · #3 09-26-2019, 12:49 AM

Quote:

Originally Posted by Guessed

May be lost in translation.

Template should be saved as (.dotm). Document should be saved as (.docx). Which module is the Document_Open saved in?

Thank! In the TnisDocument module. Did you manage to repeat my situation? Did the macro work? If the template is .dot and the document .doc will not work?

gmayor · #4 09-26-2019, 02:06 AM

The code should work as long as the document created from the template can still see the template that contains the code. If the document is e.g. sent to a third party, then the document will no longer see the template and the code will not be available.

If you want the code to run when the document is created the macro should be Document_New

ukzrsuwy5p · #5 09-26-2019, 03:28 AM

Quote:

Originally Posted by gmayor

The code should work as long as the document created from the template can still see the template that contains the code. If the document is e.g. sent to a third party, then the document will no longer see the template and the code will not be available.

If you want the code to run when the document is created the macro should be Document_New

The document can see the template, but the macro code does not work. If we open the template and enable macros, then the macro code works. Next, save the template as a document, open the document, enable macros, the macro code does not work.

gmayor · #6 09-26-2019, 04:18 AM

Make the template trusted or put it in a trusted location and try again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Word 2007 macro to work in Word 2003	Kamaflage	Word VBA	1	02-25-2015 11:40 PM
Why don't grammar/spell checks work in Word 2007?	esjayy	Word	5	03-12-2014 06:59 PM
why don't my shortcut links work any more in word 2007?	gayb63	Word	3	07-08-2012 10:48 AM
Word 2007 Font Color Doesn't Work	nnicko	Word	2	04-16-2010 01:21 PM
Annoying work in Word 2007	CabbageTree	Word	2	03-15-2010 01:47 PM