Forum Discussion

alex kramer's avatar
alex kramer
Copper Contributor
Jan 04, 2018

Need to edit a VBA script that automatically closes Excel

I have an Excel XLSM that is invoked by Windows Task Scheduler at a specific time each week. It updates a worksheet, saves a report (using "save as PDF"), closes the workbook and then exits Excel. How can I get to the code to edit it? Since the macro closes Excel automatically as soon as I open the workbook?

Thanks - Any suggestion is appreciated...

All on a single desktop in Windows 10

Excel - Office 365

 

4 Replies

No RepliesBe the first to reply

Resources