prompting user for the directory to save an excel file to

[Guest]

Can I design a macro in excel that asks the user for the filename and
directory path?

 

[Dave Peterson]

Take a look at VBA's help for application.getsaveasfilename