Saving Current Macro Enabled Workbook

[brentjohn]

Greetings!
I am struggling with creating a macro to save the current active macro enabled workbook to another name and close, and keep the current active macro enabled workbook open.
Any help will be greatly appreciated.

[BadlySpelledBuoy]

Does this work?

Please Login or Register  to view this content.

Obviously change the path and file name to suit.

BSB

[brentjohn]

I am using the following code, but does not allow for the current workbook to say open.

Please Login or Register  to view this content.

[BadlySpelledBuoy]

In your code what is in cell B1 on Sheet1 and what is allocated to the variable SvName?

BSB

[brentjohn]

BSB,
Sorry, I pasted the wrong code - see below. Cell B1 on sheet 1 contains: "Summary_Report".

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Maybe this?

Please Login or Register  to view this content.

You may need to allocate the path and file extension too, but it's not fully clear from your code if that's already done.
For example, what is "filename2"?

BSB