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