Thread: Progress Bar Control

Hi Bob,
Can I send you the code in Pdf? The code starts with Sub Refreshcharts on Page 2.

I'm aware that it's not the tidiest of projects... it was the first thing I ever programmed so be gentle!

As you will see it's 42 pages long, and it's the sections starting at page 27 that take the longest (opening files processing and copying). There are three looping sections that do this...

Thanks Bob,

Gareth

Originally Posted by Bob Phillips

What does the code that you have look like?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"pianoman" <pianoman.29agez_1150114505.4904@excelforum-nospam.com> wrote in
message news:pianoman.29agez_1150114505.4904@excelforum-nospam.com...
>
> Hi Bob/Tom,
> Thanks for your replies... sorry I didn't reply sooner, I couldn't
> get onto this site for some reason last week...
>
> Bob,
> Sorry, but it's still double-dutch to me. I still don't understand
> what code I need to place where to integrate it with my own code.
>
> Tom,
> Similarly, using the status bar would be ok I guess, but how do I
> integrate it with my code to make it work?
>
> I've since used a different approach so I can draw a line under the
> project and hand it over... I just activate a new screen that states
> 'Your report is running... Please wait' Obviously this is not perfect,
> as there is no progress indication, and if it freezes, there's no help,
> but at least it's calms peoples nerves initially!
>
> I'd still be interested to learn how to do what I'm trying to do, but
> I understand if you guys don't want to explain it all again in
> novice-speak!
>
> Thanks for all your help.
>
> Regards,
> Gareth
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=549368
>