rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Fri Apr 28 16:27:54 CDT 2006
We are in the process of slowly upgrading to Office 2003 but still mainly use Access 97. In one of my Access 97 apps I'm using the OutputTo command to export a report to Excel then via code I'm opening the excel spreadsheet and running an Excel macro to clean up the spreadsheet. This works fine with Excel 97 but when Excel 2003 tries to open the spreadsheet I get an error that the open method fails in the excel object. If I go to Excel 2003 and manually open the spreadsheet I get a message that tells me Excel automatically repaired the sheet and the problem is it "renamed invalid sheet name". The sheet name is just Sheet1 as far as I can tell. Any ideas? TIA Rusty Hammond IT Dept. - B-20 CPI Qualified Plan Consultants, Inc. (620) 793-8473 ext. 416 rusty.hammond at cpiqpc.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. **********************************************************************