Save as Script

[Lonney]

Hello All,

I have 2 Workbooks which use the same code listed below to save each Workbook. The issue is, the below code will not work when both Workbooks are open. I am receiving the following error:

Run-Tim error '1004':

You cannot save this workbook with the same name as another open workbook or add-in. Choose a different name, or close the other workbook or add-in before saving.


Both Workbooks have a different name. I cannot figure out the issue. Any direction would be appreciated.
---------------------------------------------

Sub SaveFileWhiteBoard()

 Application.DisplayAlerts = False
        
        ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\lonneyk\Google Drive\WhiteBoardBinary.xlsm", FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
        
        
Application.DisplayAlerts = True
StartTimerWhiteBoard

End Sub

Moderators note: Lonney, you almosy had teh code tags correct You need to use [ not <

[GC Excel]

Seems like your saving both workbook under the same name "WhiteBoardBinary.xlsm"

"C:\Users\lonneyk\Google Drive\WhiteBoardBinary.xlsm", FileFormat:= _

So when you save as the first workbook it is renamed "WhiteBoardBinary.xlsm" and it stay open.
That's why you get the error when you try to saveas the 2nd workbook.

Is this really what you want (ie. save under the same name) ? If not, change the saveas name in both macro.

[Lonney]

It would seem that way according to the error nessage, but my second workbook is coded to save that file as a totally different name. This error only happens when both fikes are running.

[GC Excel]

Hi,

Try replacing "ActiveWorkbook" with "ThisWorkbook" in your code.
That way, you are sure that the macro is executed in the workbook containing the macro, NOT the activeworkbook at the time the macro is run.

[Lonney]

Ahh - I bet that is the issue! I wont be able to test until tomorrow. I will update after this thread after. Thanks!.

Hi,

Try replacing "ActiveWorkbook" with "ThisWorkbook" in your code.
That way, you are sure that the macro is executed in the workbook containing the macro, NOT the activeworkbook at the time the macro is run.