Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Menus and Toolbars / October 2003

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Patrick Gibbons - 29 Sep 2003 06:34 GMT
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
fnkleroi@hotmail.com
Cindy Meister  -WordMVP- - 30 Sep 2003 14:23 GMT
Hi Patrick,

Your problem description is unclear.

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

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Patrick Gibbons - 02 Oct 2003 19:27 GMT
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
fnkleroi@hotmail.com

> Hi Patrick,
>
[quoted text clipped - 12 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
Cindy Meister  -WordMVP- - 03 Oct 2003 10:21 GMT
Hi Patrick,

> Problems:
> 1 The menu is being added to Normal.dot, I need it to be saved with
[quoted text clipped - 4 lines]
> I think that is it . . .  This is probably too much but you know what
> I am trying to do now.

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://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.