asynchronous Procedure Calls
Can anyone point me to a good resource on writing asynchronous procedure
calls? I am particually interested to know if it is possible to do an asynchronous call on the application.run("") procedure. - Rm |
asynchronous Procedure Calls
Robert,
I think Excel (in any single instance) is single-threaded, so I'm not surre it supports true asynchronous calls. Tim. -- Tim Williams Palo Alto, CA "Robert Mulroney" '''' wrote in message ... Can anyone point me to a good resource on writing asynchronous procedure calls? I am particually interested to know if it is possible to do an asynchronous call on the application.run("") procedure. - Rm |
asynchronous Procedure Calls
I just want to be able to a cancel button to a form so users can end a
calculation if it's taking too long. "Tim Williams" wrote: Robert, I think Excel (in any single instance) is single-threaded, so I'm not surre it supports true asynchronous calls. Tim. -- Tim Williams Palo Alto, CA "Robert Mulroney" '''' wrote in message ... Can anyone point me to a good resource on writing asynchronous procedure calls? I am particually interested to know if it is possible to do an asynchronous call on the application.run("") procedure. - Rm |
asynchronous Procedure Calls
in your case, you can put "DoEvents" inside the long calculation/loop
so vba can catch the cancel button events still it is not asynchronous and it's not the best way, but it's simple "Robert Mulroney" wrote: I just want to be able to a cancel button to a form so users can end a calculation if it's taking too long. "Tim Williams" wrote: Robert, I think Excel (in any single instance) is single-threaded, so I'm not surre it supports true asynchronous calls. Tim. -- Tim Williams Palo Alto, CA "Robert Mulroney" '''' wrote in message ... Can anyone point me to a good resource on writing asynchronous procedure calls? I am particually interested to know if it is possible to do an asynchronous call on the application.run("") procedure. - Rm |
asynchronous Procedure Calls
Yeah, I would normally do that but the procedure that I'm calling is from a
3rd party product, I have no control over the function I'm trying to cancel. At the moment my fuction looks something like this: public sub doCalc() frmCCPending.show Activesheet.calculate ' I want to call this async Application.run("onCalculateHandler") frmCCPending.hide End Sub and we wait on the last line. I'd like to have a cancel button on frmCCPending that ends the async call. The procedure "onCalculateHandler" is defined in a locked 3rd party addin so I can't alter it and put a doEvents call in it. - Rm "Alvin" wrote: in your case, you can put "DoEvents" inside the long calculation/loop so vba can catch the cancel button events still it is not asynchronous and it's not the best way, but it's simple "Robert Mulroney" wrote: I just want to be able to a cancel button to a form so users can end a calculation if it's taking too long. "Tim Williams" wrote: Robert, I think Excel (in any single instance) is single-threaded, so I'm not surre it supports true asynchronous calls. Tim. -- Tim Williams Palo Alto, CA "Robert Mulroney" '''' wrote in message ... Can anyone point me to a good resource on writing asynchronous procedure calls? I am particually interested to know if it is possible to do an asynchronous call on the application.run("") procedure. - Rm |
All times are GMT +1. The time now is 02:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com