G
Guest
Good morning,
I have an issue with Word 2003. I have built a number of templates that fire
code in the Document_New() sub to connect to a SQL database and fill in
values of a bunch of bookmarks.
If I have a copy of the template open (say Fred.dot), and then open a new
document based on the template all works correctly and I am propmpted to save
Document2 (or 3, 4 etc) when i go to close the new document.
If the template is not open, and I open a new document based on it the code
runs and gets the data (have used message boxes to confirm this) and bounces
round the bookmarks but does not write the data to the document. When I go to
close it I am prompted to save Fred.dot instead of Document2 (or 3, 4 etc).
Any ideas?
I have an issue with Word 2003. I have built a number of templates that fire
code in the Document_New() sub to connect to a SQL database and fill in
values of a bunch of bookmarks.
If I have a copy of the template open (say Fred.dot), and then open a new
document based on the template all works correctly and I am propmpted to save
Document2 (or 3, 4 etc) when i go to close the new document.
If the template is not open, and I open a new document based on it the code
runs and gets the data (have used message boxes to confirm this) and bounces
round the bookmarks but does not write the data to the document. When I go to
close it I am prompted to save Fred.dot instead of Document2 (or 3, 4 etc).
Any ideas?