Re: how to pause a 'save-as' and continue after input

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have a look at Application.GetSaveAsFilename. You can capture the
value entered by the user and pass it to your SaveAs code. Kinda hard
to help without seeing your current code.

Mikeeusa wrote:
I have a Master workbook that needs to be renamed before use so that the
master remains blank of data and ready for the next event. I need a way to
pause the macro and let the user enter a new name, hit save and the macro
continue. Currently when I try to record, I hit file/save-as and the save
window opens, awaiting input, I then cannot pause or stop recording as it
blips me as there is no input. I don't want to have the new name inserted as
it will change every 6 months.
I would be satisfied with the macro stopping after the save-as window is
opened so the user could input a new name and manually save it.
Please be specific on where to place the code as I am an intermediate on
macro's and worse on VBA. I do know how to step into it, but very
unknowledgeable on editing the code.
thanks

.

Quantcast