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
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
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
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,