[AccessD] Exporting and opening excel spreadsheet

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.
**********************************************************************



More information about the AccessD mailing list