VB Ole Timeout - Excel

Does anybody know how to get around the OLE Timeout Error that occurs when trying to pass information from VB to Excel. I can't find any reference in the Win95 Registry to control this and I haven't seen any thing like the SQL timeout control.
dreadnaughtAsked:
Who is Participating?
 
covingtonConnect With a Mentor Commented:
Thanks!

Glad I could help.
0
 
dreadnaughtAuthor Commented:
Edited text of question
0
 
dreadnaughtAuthor Commented:
Adjusted points to 250
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
covingtonCommented:
If you want to wait longer, change the value of App.OleRequestPendingTimeout

If you want to trap the error, look into App.OleServerBusyRaiseError
0
 
dreadnaughtAuthor Commented:
Since posting this Quiestion I ah dalready found the App.OleRequestPendingTimeout settings. The problem that now stumps me, is how do I edit these settings. I have been unable to do so through the APP/IDE/REGISTRY.

This then leaves me back at square one.
0
 
dreadnaughtAuthor Commented:
Since posting this Quiestion I had already found the App.OleRequestPendingTimeout settings. The problem that now stumps me is, how do I edit these settings. I have been unable to do so through the APP/IDE/REGISTRY.

This then leaves me back at square one.
0
 
covingtonCommented:
How do you edit them? I'm confused-

You Just say App.OleRequestPendingTimeout = <your new setting>

Or am I really missing something here...?
0
 
dreadnaughtAuthor Commented:
Sorry for the confusion. I was trying to evaluate the command instead of set it.
i.e. ?App.OleRequestPendingTimeout = <your new setting>  instead of just App.OleRequestPendingTimeout = <your new setting>, without the ?????.

I think that you earned these points for at least my stupidity.!!!!
0
 
dreadnaughtAuthor Commented:
Covington, please post blank answer for points!
0
All Courses

From novice to tech pro — start learning today.