ExcelBanter - prompting user for the directory to save an excel file to

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - prompting user for the directory to save an excel file to (https://www.excelbanter.com/excel-programming/386802-prompting-user-directory-save-excel-file.html)

kiwiwulf

prompting user for the directory to save an excel file to

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

Dave Peterson

prompting user for the directory to save an excel file to

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

kiwiwulf wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 05:16 PM.