Save As macro

[tjgriffi]

I have been having trouble getting a macro to work like I
want.

I want a macro to "save as" wookbook that will change
drive and folder in the "save as" "save in window" that
will allow me to change the file name but populate the new
drive and folder automaticly but allow me to input new
file name.

I have been able to create a statement, but I have to
manually change drive. I want to accomplish the change of
drive and folder w/o manual intervention.

 

[Tom Ogilvy]

Don't know if this is what you want, but give it a try.


Chdrive "D"
Chdir "D:\My Documents"

fname = Application.GetSaveAsFileName()