Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Progress bar/meter for duration of code - No loop

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 373
Default Progress bar/meter for duration of code - No loop


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Progress bar/meter for duration of code - No loop

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Progress bar/meter for duration of code - No loop

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 ***
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default Progress bar/meter for duration of code - No loop

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 ***





  #6   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 145
Default Progress bar/meter for duration of code - No loop

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 ***



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
progress meter for Calculation? Pausert of Nikkeldepaiin Excel Discussion (Misc queries) 8 December 14th 07 07:14 PM
pls help ammend progress bar code Susan Excel Programming 4 December 28th 06 06:03 PM
Using progress bar with existing loop Jeff Roper[_6_] Excel Programming 1 November 18th 04 05:43 AM
Trying to adapt progress meter hotherps[_144_] Excel Programming 0 October 17th 04 02:46 PM
Progress Meter during macro execution Rob[_21_] Excel Programming 7 June 22nd 04 06:36 PM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"