Handshaking problems between Access and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kjell - 16 Jan 2006 11:16 GMT

Hi,
I'm using Excel from Access VBA to create a graph. Access starts Excel and
loads an .xls-file with an Excel Macro. Access the starts the Excel macro.
The Excel macro loads the .xls-file with the data and creates the graph. VBA
in Access saves the graph and quits Excel. During this sequence Excel is
hidden to the user.
My problem is that some handshaking problem occurs when Excel quits and the
control returns to Access. I receive a message saying that " .... a
unexpected problem has ocurred...." The system then creates a report to
Microsoft for this problem.
The problem never occurs if I let Excel be visible to the user during the
same sequence.

Why does this problem occure and how do I solve it?

Access 2002, Excel 2002

Any help is appreciated!

Signature

Kjell

Reply to this Message

Dirk - 16 Jan 2006 11:37 GMT

Hmm as far as I know application crashes shouldn't happen if you stick to the
default VBA + DAO + Office extensions. I have had similar application crashes
in some cases that were reproducable on other systems. The only thing you can
do is try to avoid doing whatever it is that made the system crash in the
first place. Since you cannot go into Office's sourcecode and fix there is
nothing you can do except create workarounds.

> Hi,
> I'm using Excel from Access VBA to create a graph. Access starts Excel and
[quoted text clipped - 14 lines]
>
> Any help is appreciated!

Reply to this Message