Opening Excel file from Access

[Gumby]

Hi Guys!

I am having problem opening up an Excel file from Access. I am using Access 2000 and Excel 2000.
The problem is that I can open it up OK on one machine but I can't open it up on another machine. The Excel file is in the folder where the Access file is looking for it.

The error that it gives is
"The expression may not result in the name of a macro, the name of a user-defined function or Event Procedure. There may have been an error evaluating the function,macro or an event"


Although, it works fine when I tried it on another machine.



Any ideas anyone?


Would appreciate your help.

Thanks

 

[Fizzio]

Post the code you are using to open the file

(And delete your other 2 posts with the same question - Only post to 1 topic. If you are not sure where to put it, put it in the General forum)

 

[boblarson]

Since I don't know where you posted this, other than the Modules & VBA category, I will answer here.

Sounds like you have a MISSING REFERENCE problem on the other machine.

If you need more info about Missing References, do a search, there's many posts about it.