insert "save as" in macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro to open a document but I want it to also give me the "save as"
screen right away. I tried this but can't click stop on the macro from the
"save as" screen. Thanks!
 
If you are opening a document and going immediately to Save As, your
document probably should be a template and you should be using File > New.
Then the document on the screen will have all the text from your template
but will be a new document and the user will have to give it a new name to
save it. It is very difficult to write over the original template.

To get the SaveAs dialog box, you need to write code. If a template is not
what you want, write back and I or someone else will give you directions.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 
Every initial save is a Save As, though.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Charles' and Suzanne's posts were each helpful. My problem was that,
although I had tried using a template, I wasn't opening it as a template.
Once I opened it as a template and it assigned Document # as the temporary
name, it gave me the save as screen even if I inadvertently clicked CTRL-S.
Now that I have my macro set up to open the template the proper way, I think
my problem is solved! Thanks!!!
 
Uhm - the proper way to use a template is to create an new document.

When you save that document you'll need to assign a name.

If it isn't working this way, and if you have a Word template, something is
wrong.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide


--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top