Just wondering how I would get a macro to pause to allow me to change a filename and then when I hit enter, it continues.
I use it to export excel worksheets to our webserver and it works now, but overwrites the file name everytime. I want to change the filename before saving.
Any help appreciated.
Bookmarks