ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   invalid sheet name problems (https://www.excelbanter.com/excel-programming/336294-invalid-sheet-name-problems.html)

Ben

invalid sheet name problems
 
I am using crystal reports to export data to an excel spreadsheet. in office
2000 the spread sheets open fine, but in office 2003 or office xp i get an
error saying that office was able to open the file but had to rename an
invalid worksheet. The sheet is originally names Sheet1. How can i fix this
issue?

This is an issue because I am currently writing a script that will take
multiple excel spreadsheets and import them into a sql server database. when
i go to open the excel spread sheets via the script i get an error saying
that an error occured, but the engine running the script does not know what
error. I think this is the error because if i rename the sheets and try the
script again, it works.

thanks for any and all help!

Ben


All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com