Is there a way of pausing a macro

[Guest]

Hi i am trying to record a macro to create a new worksheet and then save it
as the title of that worksheet but i cant get the macro to pause or wait for
me to enter in the file name and it just keeps trying to give the sheet the
same name that i saved it to when i was recording it. Is there a way of
getting it to pause so thta i can enter in the file name before it continues
with the rest of its instructions

 

[Guest]

Add test code to your macro

1) Use an Inputbox so you can type in information
2) add a statement line Myfilename = "c:\temp\testfile.txt"
3) Write test code that writes too cells on the spreadsheet
Range("A3") = "Test Data"

 

[JE McGimpsey]

Take a look at the GetSaveAsFileName method in VBA Help.