saving files

H

Haigy

i would like to write a bit of code to add to all my documents in the
company so that when they click the save as button it will open a specific
directory

how can i do this

thanks
 
J

Jay Freedman

Hi, Haigy,

The code to put into your macro to set the path is shown at
http://www.mvps.org/word/FAQs/MacrosVBA/ChangeSaveAsPath.htm.

You should put code into a macro named FileSaveAs() to intercept the SaveAs
command, as explained in
http://www.mvps.org/word/FAQs/MacrosVBA/InterceptSavePrint.htm.

To make this company-wide, you need to distribute a template containing the
macro to everyone who uses your documents. That can (and should) be a
template used to create specific types of documents through the File > New
dialog, rather than a global template that would affect every SaveAs for
every document. For this, read
http://www.mvps.org/word/FAQs/MacrosVBA/DistributeMacros.htm.
 

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

Top