problem with using Excel functions from Access

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
 
C

Cecilia Reyes

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
 

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

cannot use Excel functions from Access 0
Access 2003 and excel 0
problem with using Excel functions from Access 0
A couple questions BEFORE using Office 365 0
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
Automating Excel from Access 8
Access VBA Not Saving Excel 0
Run code in Excel from Access 4

Top