I have setup an automated script to run a SQL statement that will overwrite the data on a current worksheet, but I receive an error when i try to open the excel file after the automation runs. I do have VBA coded buttons on the workbook, but they are located on another sheet, and not the one I am trying to overwrite.
The error I am getting reads the following:
Excel found unreadable content in ‘NEW Template Button idea v1.02xlsm - Toad Test Form.xlsm’ Do you want to recover the contents of this workbook? If you trust the source of thsi workbook, click yes
I can then press yes and the workbook will open with the new query results populated to the workseet I specified, but the Buttons on another worksheet are gone. This is the first time I have used VBA or Toad automation.