problem with using Excel functions from Access

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi everybody,

Before, everything was perfect until they gave me a new
computer and reinstalled everything.
Now, when I'm trying to use some Excel functions such as:
Set xlbook = xlapp.Workbooks.Open("...")
from my Access application I'm getting a message:
"MSACCESS.exe has generated errorsand will be closed by
Windows. You will need to restart the program. An error
log is being created."

I would appreciate if anybody could clarify it.

Thanks advance,

Alex
 
Are the object libraries properly installed? the ones you reference from vba, i mean..

----- Alex wrote: ----

Hi everybody

Before, everything was perfect until they gave me a new
computer and reinstalled everything
Now, when I'm trying to use some Excel functions such as
Set xlbook = xlapp.Workbooks.Open("..."
from my Access application I'm getting a message
"MSACCESS.exe has generated errorsand will be closed by
Windows. You will need to restart the program. An error
log is being created.

I would appreciate if anybody could clarify it

Thanks advance

Ale
 
Back
Top