progress bar

[john.9.williams]

hi,

I have a macro that opens up a word document thats sits on a server,
the document takes a while to open, and it does seem that the program
has stalled until the doc appears, is there anything that i can display
on screen like a userform/progress bar that keeps going/loading until
the doc appears

thanks you clever lot

Johny5

 

[Norman Jones]

Hi Johny5,

See John Walkenbach's web site for the follqwing suggestion:


http://j-walk.com/ss/excel/tips/tip34.htm

 

[Bob Phillips]

Don't think that this will work, as the technique needs some interrupt
points to update the bar, whereas there will only be one in this instances,
when it has finished. I think you need some sort of asynchronous bar, which
would probably mean that it is not a true state of progress, rather a visual
indicator.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Michael Bednarek]

See John Walkenbach's web site for the follqwing suggestion:


http://j-walk.com/ss/excel/tips/tip34.htm

With respect to J Walkenbach, but that will not address th OP's
question.

Johny5: when Office documents are opened in their own applications, a
small progress bar is usually shown in the status bar. If an Excel
workbook opens a Word document, no such mechanism is available. You
could try to obtain the document's file size before openening it and,
based on some guesstimates, show a modeless message, warning the user of
possible delays ("...this might take some time").

 

[Guest]

Why not have a splash screen show with a msg and close when the doc is
displayed?.

 

[Norman Jones]

Hi Bob,

Don't think that this will work, as the technique needs some interrupt
points to update the bar,

I should have read more closely.

Thank you for the correction.