Doubt with save as.

[rajeshvk33]

Hi,

I recorded macro.When i give Save as recorded macro also get inherited to new macro created.
Please suggest me how to avoid above.

Example :
I record macro ( SAV ) in Book1.xls.when i run the SAV macro and give files save as Book2.xls.
Book2.xls also inherit the macro saved in Book2.xls

Thanks in Advance.

 

[james_lankford]

maybe record a new macro, but make the first step to pen a new workbook, then do a saveAs for the new workbook, then stop recording the macro
that way one workbook is the "driving" program that creates and saves the "data" workbook