Macro to Save Filename

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Franko - 06 Sep 2006 19:31 GMT

Creating a macro to modify a document, then save the document with the same
filename in a different directory. While creating the macro, i do a "File,
Save As" and select the location, but cannot get the open file name.

Reply to this Message

Jezebel - 06 Sep 2006 22:37 GMT

You can't create macros like this using the recorder. You need to write
something like --

ActiveDocument.SaveAs FileName:="C:\...."\ & ActiveDocument.Name

> Creating a macro to modify a document, then save the document with the
> same
> filename in a different directory. While creating the macro, i do a "File,
> Save As" and select the location, but cannot get the open file name.

Reply to this Message