Hi Bob,
I've attached the file in Pdf... the code starts with Su
Refreshcharts on Page 2.

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

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

Thanks Bob,

Gareth

Bob Phillips Wrote:
What does the code that you have look like?

--
HTH

Bob Phillips

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

"pianoman"
wrote in
message ...

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 no
perfect,
as there is no progress indication, and if it freezes, there's n
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


+-------------------------------------------------------------------
|Filename: Risk Charts.pdf
|Download: http://www.excelforum.com/attachment.php?postid=4884
+-------------------------------------------------------------------

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54936