Automatically Open file when closing another?

K

KJ

Thought there was a way to do this, but now can't remember:

I have a blank quote form I use, but I never save the changes, only file a
hard copy.
Is there a way to have another file, call it "Quote Log" open (so I can make
a note of who/when etc) when I close the "Blank Quote" file?
Any help ??

Thanks, Ken.

BTW, running office 07 if it makes a difference
 
G

gls858

KJ said:
Thought there was a way to do this, but now can't remember:

I have a blank quote form I use, but I never save the changes, only file a
hard copy.
Is there a way to have another file, call it "Quote Log" open (so I can make
a note of who/when etc) when I close the "Blank Quote" file?
Any help ??

Thanks, Ken.

BTW, running office 07 if it makes a difference
Click to expand...

Why not do a "save as" once you have the the form filled
out. You would still have the blank form and a saved copy
with all of the info filled in. No second program or quote
log. You could store them in folders by date or customer or
whatever makes sense to you.

gls858
 
B

Beth Melton

You can use a macro and the Document_Close event to trigger the opening of
your log file.

If you need help with your macro then the best place to post is in one of
the Word VBA newsgroups.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Top