Forum Discussion
alex kramer
Jan 04, 2018Copper Contributor
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