calenger
03-09-2006, 01:28 PM
Hi All
Quick question. I have an excel app that queries an as400 through ado. Works fine but i want to add a progress bar so the user knows its still running. unfotunatly the progress bar does not update (repaint i think). So i gave up on the progressbar and started to use the satus bar to show a percentage of completion. it worked fine up till about 27 % and then the window stopped updating similiar to the progress bar. after about 40 min the app finished and everything refreshed and was correct. I am using the screenupdating = false in the begining of a for loop and turning it back on at the end iof the loop. Also have shut off calculation. The funny thing is that if I try to run it again without closing excel and reopening the status bar never updates. If I reopen it and start it over again it does update to about 27 % and then seems to hang again.
Any thoughts?
sorry guess it was not that quick :)
Quick question. I have an excel app that queries an as400 through ado. Works fine but i want to add a progress bar so the user knows its still running. unfotunatly the progress bar does not update (repaint i think). So i gave up on the progressbar and started to use the satus bar to show a percentage of completion. it worked fine up till about 27 % and then the window stopped updating similiar to the progress bar. after about 40 min the app finished and everything refreshed and was correct. I am using the screenupdating = false in the begining of a for loop and turning it back on at the end iof the loop. Also have shut off calculation. The funny thing is that if I try to run it again without closing excel and reopening the status bar never updates. If I reopen it and start it over again it does update to about 27 % and then seems to hang again.
Any thoughts?
sorry guess it was not that quick :)