I have an Excel add-in that downloads database data directly into my spreadsheet. Yesterday I renamed it "file-copy.xls" and renamed it back to the original "file.xls". IT KNOWS. Now it won't download any data.
Error is: CANNOT RENAME A SHEET TO THE SAME NAME AS ANOTHER SHEET, A REFERENCED OBJECT LIBRARY OR A WORKBOOK REFERENCED BY VISUAL BASIC.
The database provider denies all knowledge of any error like this. I looked in MS Technet and couldn't find anything close.
Any suggestions? How does it know it was renamed?
Error is: CANNOT RENAME A SHEET TO THE SAME NAME AS ANOTHER SHEET, A REFERENCED OBJECT LIBRARY OR A WORKBOOK REFERENCED BY VISUAL BASIC.
The database provider denies all knowledge of any error like this. I looked in MS Technet and couldn't find anything close.
Any suggestions? How does it know it was renamed?