Exporting to Microsoft Excel 2003

  • Thread starter Thread starter djouungk
  • Start date Start date
D

djouungk

I've seen several websites and newsgroup entries that allude to a
"acSpreadsheetTypeExcel11" constant for the TransferSpreadsheet
command. I cannot figure out how to use this to get my worksheets to
export into 2003 format. If anybody has a bit of help, it would be
greatly appreciated. The most I see in my object browser is 9.

Thanks,
Doug
 
To the best of my knowledge, Excel 2003 did not introduce a new file format,
so there is no such thing as 'Excel 2003' format. (The UI refers to the
current format as 'Excel 97/2003 format'). Either 'acSpreadsheetTypeExcel8'
or 'acSpreadsheetTypeExcel9' should work for you. (They actually have the
same numeric value, they're just different names for the same value).

Where did you see the reference to 'acSpreadsheetTypeExcel11'?
 
BTW: I just checked Access 2007. There are two new members of the
'AcSpreadsheetType' enum in Access 2007, 'acSpreadsheetTypeExcel12' and
'acSpreadsheetTypeExcel12Xml', but no 'acSpreadsheetTypeExcel11'.
 
Hmmmm, well I try to export an access query to excel using the Excel9
constant and when it gets e-mailed to my pda, it won't open. If I open
it in excel on my computer and go to File->Save. Then it opens fine on
the PDA. Obviously, this is not the way to go.

PDA has Microsoft Mobile 5.0 on it.
 
I'm not familiar with Windows Mobile, so I'm afraid I don't think I'm going
to be able to help you further with that one.
 
Back
Top