VBA Close With Save Causes Runtime Error

Jefferson2512

Board Regular
Joined
Sep 16, 2019
Messages
53
I'm running a macro that closes the current workbook. The macro is run by an icon on the QAT and the code is in the MyWB.xlsm project. When the last VBA command is executed (ActiveWorkbook.Close SaveChanges:=True)), I get the 'Automation Error. Exception Occured'. When MyWB.xlsm is active and I run the same code in the 'Personal.xlsb' workbook, the error does not occur.

Any help wuold be appreciated. Thanks.
 

Forum statistics

Threads
1,085,161
Messages
5,382,071
Members
401,768
Latest member
JAWHARRAH

Some videos you may like

This Week's Hot Topics

Top