PDA

View Full Version : Macro letting the user decide where to save the file (and decide the filename)



sb003848
08-06-2009, 10:56 AM
Hello,

Is there a way to launch a macro that asks the user where to save the file before going through with the changes coded in the macro???

Thanks...

Bob Phillips
08-07-2009, 05:30 AM
Yes, it is simple. Look at GetSaveAsFilename in VBA help.