Hello,
My problem is with the OLE server timing out
and giving a Server Busy message box during execution of a VB Excel macro.
The Server Busy message box requires user input, and the purpose of the macro is to eliminate user input until other calculations, etc. are done.
There is a way to re-set the OLE timeout in standalone VB:
App.OLEServerBusyTimeout = 20000
that will take care of the problem, I think.
However, when trying to use this in VB within Excel,
the App variable is not defined. I can not find any other reference to this in the VB Excel help.
How can I get VB within Excel to recognize the standalone VB App object?
Is there a way to import or reference this object in VB Excel from standalone VB?
Is there another solution to extend the OLE server timeout within VB Excel?
Thank you.
My problem is with the OLE server timing out
and giving a Server Busy message box during execution of a VB Excel macro.
The Server Busy message box requires user input, and the purpose of the macro is to eliminate user input until other calculations, etc. are done.
There is a way to re-set the OLE timeout in standalone VB:
App.OLEServerBusyTimeout = 20000
that will take care of the problem, I think.
However, when trying to use this in VB within Excel,
the App variable is not defined. I can not find any other reference to this in the VB Excel help.
How can I get VB within Excel to recognize the standalone VB App object?
Is there a way to import or reference this object in VB Excel from standalone VB?
Is there another solution to extend the OLE server timeout within VB Excel?
Thank you.
