How would one remove the reference to Normal.dot on a document?

How would one remove the reference to Normal.dot on a document?

Post by Patrick Gi » Tue, 30 Sep 2003 14:34:43


Any ideas?

If someone has word open I'm getting grief when I open up my document update
my customized menu from Excel and close. If the reference were not there I
would be able to open, update, and close without Normal.dot getting in the
way.


Please contact me if you have any questions,

Patrick Gibbons
XXXX@XXXXX.COM
 
 
 

How would one remove the reference to Normal.dot on a document?

Post by Cindy Meis » Wed, 01 Oct 2003 22:23:35

Hi Patrick,

Your problem description is unclear.


Cindy Meister
INTER-Solutions, Switzerland
http://www.yqcomputer.com/ (last update Jan 24 2003)
http://www.yqcomputer.com/

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

 
 
 

How would one remove the reference to Normal.dot on a document?

Post by fnklero » Sat, 04 Oct 2003 03:27:28

Alright, from the start (sorry that it was unclear, you mean you can't
read my mind?!):
What I am trying to do:
1 Setup a Word document to be able to import created graphs or tables
from an Excel workbook, wherever the cursor is in the Word doc.
2 Setup a mechanism to update those graphs or tables in the word
documents when the Excel versions have changed, if the user would like
them updated.
3 Setup a mechanism to keep 2 types of files, those that are updated
as the Excel graphs and tables are updated, and those that are not
updated.
4 Setup a mechanism to update the Word documents so that they have the
newest graphs and tables available to them in the dynamic files.

How I am doing it:
1 It was decided that a custom menu in the Word document was the best
way to allow a user to grab a graph or table. The menu shows the user
what they can grab, "3 Month", "6 Month", etc. The menu entries have
a "GrabGraphOrTable" function and the menu control's tag has the name
of the graph or table to grab, "grph3Mon", "grph6Mon", etc.
2 When a graph or table is placed into the Word document a bookmark is
placed, then when the Excel graphs or tables are updated it goes
through the dynamic files going to each bookmark deleting the graph or
table and replacing it with the newest version.
3 There are 2 folders containing the Word documents, "Static" has the
static files, "Dynamic" has the dynamic files. The updates will be
done to all of the files in the Dynamic folder.
4 I decided to populate that menu from Excel, thus updating it as
needed.

Problems:
1 The menu is being added to Normal.dot, I need it to be saved with
the document itself or a seperate template which only these dynamic
files will access.
2 If Normal.dot is already opened by the user it bombs.

I think that is it . . . This is probably too much but you know what
I am trying to do now.

Thank you for your time,

Patrick Gibbons
XXXX@XXXXX.COM
 
 
 

How would one remove the reference to Normal.dot on a document?

Post by Cindy Meis » Sat, 04 Oct 2003 18:21:32

Hi Patrick,

Oh, no, it helps :-)

Both problems probably have the same solution. You need to set the Word
application's .CustomizationContext to the document object
(ActiveDocument, if you're not declaring an object variable) before you
start fiddling with CommandBars stuff.

Cindy Meister
INTER-Solutions, Switzerland
http://www.yqcomputer.com/ (last update Jan 24 2003)
http://www.yqcomputer.com/

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)