Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Linking a software with VBA
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Linking a software with VBA
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 -- Regards, Tom Ogilvy "Hosein Alizadeh" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in Linking a software with VBA
You can also look at this API approach shown by Rob Bovey:
http://groups.google.com/group/micro...1?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/ -- Regards, Tom Ogilvy "Hosein Alizadeh" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum with array problem using SRC/BusinessObjects software | Excel Worksheet Functions | |||
Sum with array problem using SRC/BusinessObjects software | Excel Programming | |||
Really weird problem... software glitch? | Excel Discussion (Misc queries) | |||
Problem caused by Googels personal index software! | Excel Programming | |||
REPOST: Software recommendation (Recording software) | Excel Programming |