Access 97 and Excel 2000

  • Thread starter Thread starter Bruce Palmer
  • Start date Start date
B

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)?
 
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!
 
We have just moved to Excel 2000 but continue to use
Access 97. A lot of our Access applications use the
Click to expand...


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
 
Back
Top