SaveAs to same directory but different file name

[johnnywinter]

By Code I am trying to SaveAs the present Workbook :

Only in the same directory as the present Workbook- but with a different file name .

The new file name would be :
"the Filename of the Active Workbook" + " ("D9") of the Sheet("ADMIN")"

This macro will only be run from the Sheet("Admin").

Any help or point me in the right direction will be appreaciated

[Leith Ross]

Hello johnnywinter,

If you are trying to create a path you can use with the SaveAs you can do this...

Please Login or Register  to view this content.

[johnnywinter]

Leith,

Another great solution, but I did not think out the final result.

Code works great to SaveAs, BUT it also changes the Active Workbook name to the filename that was saved as.

How can I keep the open workbook with the same name And do the Save As in the following code?

Please Login or Register  to view this content.

[Leith Ross]

Hello johnnywinter,

Let's try this method...

Please Login or Register  to view this content.

[johnnywinter]

Works perfectly.

I am learning so much for you and this site. Biggest thing I have learned is that I have so much to learn.

Thanks,