I'm a new user to this site. I'm trying to run a VBA macro in Excel once a day at midnight using the windows task scheduler. It imports data from a .txt file that gets dropped into a folder at night, and appends that data to an existing spreadsheet. I know the macro works because I've tested it numerous times. However, each morning for the past few days, when I check to see if the macro worked, I get an error message saying:
Excel experienced serious problem with "......\personal.xlsb" add-in. If you have seen this message multiple times, you should disable this add-in and check to see if an update is available. Do you want to disable this add-in ? Yes / No". I also see that both the worksheet and the personal macro workbook attempted to open each night and encountered an error.
Checking "No" means that the same problem/popup happens the next day. Checking "Yes" obviously disables the personal macro workbook, at which point I have to re-enable it in order to access my macros. I've already tried finding the personal macro workbook in the XLStart folder, deleting it, and then saving a new workbook with the same name (to no effect).
I've looked around already and can't seem to find an answer to this question, but I'm not sure how to troubleshoot the issue with the personal macro workbook. Any thoughts or advice is appreciated. Thanks!