VBA to SaveAs but keep current workbook open

[Spoonman667]

Hi Guys,

I've been using the below macro to successfully save as a new file with name and cell value reference.

Please Login or Register  to view this content.

However, I would now like to alter it (or replace it) so it keeps the current workbook open and just saves the new one to the file path. So I guess it's more of a Export As than a Save As.

Any Ideas?

Thanks,


Spoonman

[AlphaFrog]

Replace this...

Please Login or Register  to view this content.

With this...

Please Login or Register  to view this content.