Renamed Excel Spreadsheet; Now db download Fails

jbarry · Apr 19th, 2002, 03:34 PM

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?

Jack in the UK · Apr 20th, 2002, 01:28 PM

siounds stupid but i suggest change in it back to original nane

then we can work on,,,,,

jbarry · Apr 21st, 2002, 01:13 PM

I appreciate the simplicity of your answer but I did already. I've been using the spreadsheet with its original name but somehow it "knows" that it was renamed. This interface is a dog. I have 7 unanswered support requests with the interface provider. I just wish I knew more about VB and how the interface works with Excel.

Apr 20th, 2002, 01:28 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	siounds stupid but i suggest change in it back to original nane then we can work on,,,,, __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 03:34 PM	#1
jbarry New Member Join Date: Apr 2002 Location: Judy Barry Posts: 2	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?

Apr 21st, 2002, 01:13 PM	#3
jbarry New Member Join Date: Apr 2002 Location: Judy Barry Posts: 2	I appreciate the simplicity of your answer but I did already. I've been using the spreadsheet with its original name but somehow it "knows" that it was renamed. This interface is a dog. I have 7 unanswered support requests with the interface provider. I just wish I knew more about VB and how the interface works with Excel.