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
--
Thank you for reading my post. Hopefully you can answer my querie

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"


"Shazza" wrote:

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
--
Thank you for reading my post. Hopefully you can answer my querie

Take a look at the GetSaveAsFileName method in VBA Help.

In article ,
Shazza wrote:

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