SaveAs macro works once only

[BRISBANEBOB]

The code below runs once but once only. Second time it generates a syntax error at the ActiveWorkbook.SaveAs line.

It is intended to save the file as macro-enabled using a given folder in FPath and a given name which comes from a cell in the spreadsheet. There are no illegal characters in either of those (so far as I can sell). I presume it has something to do with saving it with the same name as an open file but ?

[Trebor76]

Hi BRISBANEBOB,

Your code works for me

Are you on the same sheet you were when you originally ran the macro as if you're on a different tab there may illegal characters on that tab as it uses the active tab??

HTH

Robert

[BRISBANEBOB]

Hi Robert

The DataEntrySheet (where the FName range is) is on a separate tab but I still can't see any illegal characters. It saves fine from the DataEntrySheet when it is first saved and the when it attempts to save it again from a different sheet using the above code, it merely adds a reference ("-(FP)") and I can't see anything wrong there.

[BRISBANEBOB]

Solved. It turns out when you are saving to a SharePoint folder the syntax is slightly different.

Thanks for your help, much appreciated

[Trebor76]

I didn't do too much, but thanks anyway