Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all, excuse the question, it is probably quite simple. I have
various progress meters that i have secured from this site but i see that they all run with loops but i have a series of routines that need to run and would just like to know how to fit my code in ?? Any help would be appreciated.... Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Why not just replace your "various progress meters" with one that you update after each routine is complete? If one routine takes 50% of the time, and another only 12 percent, so be it. Adjust your single progress meter accordingly. This would be like the "Overall" progress meter one sees when loading new software, instead of the progress meter for the "Current process", which you seem to be using now. Well, just a thought......James On Jul 11, 4:22?pm, Les Stout wrote: Hello all, excuse the question, it is probably quite simple. I have various progress meters that i have secured from this site but i see that they all run with loops but i have a series of routines that need to run and would just like to know how to fit my code in ?? Any help would be appreciated.... Best regards, Les Stout *** Sent via Developersdexhttp://www.developersdex.com*** |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Les,
They don't have to be in loops, but they do need some point in your code where the progress bar can be updated. Does your code have such points or is the time taken up with calls out to other apps/systems, such as OS calls? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Les Stout" wrote in message ... Hello all, excuse the question, it is probably quite simple. I have various progress meters that i have secured from this site but i see that they all run with loops but i have a series of routines that need to run and would just like to know how to fit my code in ?? Any help would be appreciated.... Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You don't show any code, so how could we know how it all could fit together
? "various progress meters" and "a series of routines" don't tell us much. Can you post a simple example of what you want to do? Tim "Les Stout" wrote in message ... Hello all, excuse the question, it is probably quite simple. I have various progress meters that i have secured from this site but i see that they all run with loops but i have a series of routines that need to run and would just like to know how to fit my code in ?? Any help would be appreciated.... Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Bob, no it is just opening files, creating sheets doing comparisons
and pasting found values to the new sheets. But i think i have cracked it thanks Bob... If i dont come right i will come back tomorrow... Good evening, cold as hell here, this weather has gone crazy !!! We had snow here about 10cm deep !!!! Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My daughter is in NZ for the ski-ing season. Day before the season started,
she was walking about in shirtsleeves, bright sunny days. Thought that there was no way that the season would start on time, but that very night they had a tremendous fall, beautiful powder snow on all slopes, and even down in Queenstown, which is rare. Something is a foot methinks. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Les Stout" wrote in message ... Hi Bob, no it is just opening files, creating sheets doing comparisons and pasting found values to the new sheets. But i think i have cracked it thanks Bob... If i dont come right i will come back tomorrow... Good evening, cold as hell here, this weather has gone crazy !!! We had snow here about 10cm deep !!!! Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
progress meter for Calculation? | Excel Discussion (Misc queries) | |||
pls help ammend progress bar code | Excel Programming | |||
Using progress bar with existing loop | Excel Programming | |||
Trying to adapt progress meter | Excel Programming | |||
Progress Meter during macro execution | Excel Programming |