Problem in Linking a software with VBA

[Hosein Alizadeh]

I have a problem linking a software with Excel (VBA).

In a command line of my macro when its time waiting to recieve results from
the software is bigger than 90 seconds, the VBA make an error. The error
message is "Microsoft Office is waiting for an OLE application". I guess it
is about run time or time out limit of VBA. Do you have ever seen this error?

 

[Tom Ogilvy]

No first hand experience with it, but in past posts on this topic others have
claimed success with

Application.DisplayAlerts = False
' code that causes the message
Application.DisplayAlerts = True

 

[Tom Ogilvy]

You can also look at this API approach shown by Rob Bovey:

http://groups.google.com/group/microsoft.public.excel.programming/msg/d82da06314e10021?dmode=source

This article show options available in VB the Language, but not in Excel.
However, the explanation might be useful.

http://support.microsoft.com/kb/q138066/