Excel object

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
 
D

dj

Not quite sure what you mean, but do you have an Excel Objetc Library reference
set in your Access database/code?

HTH,
dj
 
C

Chris Nebinger

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
 
C

ChrisBat

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

Tim Ferguson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tagging Misspell Words with "##" 0
Embed the same Excel multiple times 0
Multi-Selection with Hand-writing draw tool 0
inlineShape.OLEFormat.Activate() command fails for excel file 0
Merging from an Excel file with graphics 1
Object Browser in VBA 0
Insert multiple objects at once ? 3
Autonumber field in Excel that behaves the same as Access 0

Top