Access 97 and Excel 2000

[Bruce Palmer]

We have just moved to Excel 2000 but continue to use
Access 97. A lot of our Access applications use the
transferspreadsheet method of the docmd object. One of
the intrinsic constants is spreadsheettype. The last
constant listed is 8 (acSpreadsheetTypeExcel97). Is there
a way to get this method to work with Excel 2000 (like
maybe a download exists to update the available intrinsic
constants)?

 

[John Nurick]

Hi Bruce,

There is a new intrinsic constant (at least in Access 2002)
Const acSpreadsheetTypeExcel9 = 8
but as you can see using it makes no difference!

 

[Martha Keenan]

We have just moved to Excel 2000 but continue to use
Access 97. A lot of our Access applications use the

Dear Bruce Can you please tell me about your self
what do you do are you married with children . How many ?
I I need to talk to you . martha Keenan