Excel object

  • Thread starter Thread starter ChrisBat
  • Start date Start date
C

ChrisBat

Hi,

For some reason when I am writing in output to/input from
Excel code, my Access 2000 doesn't recognise the Excel
Object. Any ideas why?
Thanks,
Chris
 
Not quite sure what you mean, but do you have an Excel Objetc Library reference
set in your Access database/code?

HTH,
dj
 
Are you sure it is referenced in the References? From any
module, Tools->References. Microsoft Excel 9.0 Object
Library needs to be selected.



Chris Nebinger
 
That would be the problem...I haven't done that in about a
year, so how soon we forget these things...
Thanks a tonne...
 
That would be the problem...I haven't done that in about a
year, so how soon we forget these things...
Thanks a tonne...
Click to expand...

I stared at the VBEditor in Excel this afternoon trying to work out where
all the DAO objects had gone, and then remembered I had to switch them on
too...

B Wishes


Tim F
 
Back
Top