J
Joy
we are running a macro, it will interact with server, sending request and
receiving responsse.
some times, it take too long.
I have tried to use something like long transaction and give some time msgs,
but since vba does not support multithreading, I finally gave up
now, I am thinking whether we can timing how long the process takes. if it
is too long, like 300seconds, we give a msg to user and if he or she wants to
continue, then the process continues; if he/she chooses no, then the process
terminates
I am just curious how to do it. for example, if we want to export ms project
to web server by calling sub exportProject
then how to set timing on it????
I hear doEvents can do it, but cannot figure out how to do it, if someone
can give a procedure, that would be great
thank you all
receiving responsse.
some times, it take too long.
I have tried to use something like long transaction and give some time msgs,
but since vba does not support multithreading, I finally gave up
now, I am thinking whether we can timing how long the process takes. if it
is too long, like 300seconds, we give a msg to user and if he or she wants to
continue, then the process continues; if he/she chooses no, then the process
terminates
I am just curious how to do it. for example, if we want to export ms project
to web server by calling sub exportProject
then how to set timing on it????
I hear doEvents can do it, but cannot figure out how to do it, if someone
can give a procedure, that would be great
thank you all