Hi,all,
I create a statusbar on which put a progress bar on the second panel and use a timer to change the value for proress bar, everything works fine.
BUT..
Because I need to work on spreadsheet from VB program, when I call spreadsheet micro (it will take several minutes), the timer will no longer be called and there is no value be updated for progress bar. Did any of you encounter this issue? is there a way to solve this problem?

Thanks!

Hi there..

Because you are probably calling the spreadsheet synchronously, your program is waiting for it to call back, and none of the event thats occurs on your program are handled. Can you call it async?? what code are you using for the call???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Thank you for reply.

Inside my VB project function, I wrote:

Call LoadProgressBar
oExcel.run "EXCEL_Micro" 'this step takes time.
call unloadProgressBar

how to call it call it async? if I call it async, is it possible that the project will call other function that will use the results of the micro action before micro is executed?

Ok, don't have a clu on how to call it async, maybe google could help???

if you call async, maybe, MAYBE, you have some events that tell you how it is doing...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Can anybody help me how to solve this issue? it looks bad when the progressbar is shown with no value changing.
it is said that timer use another progress, why it cannot be called when I call the long time loading micro of excel, I go to google, but I didn't find answer, maybe my keywords were not accurate.

Thanks.