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

Hi Johny5,

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


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


---
Regards,
Norman



wrote in message
oups.com...
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

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)


"Norman Jones" wrote in message
...
Hi Johny5,

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


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


---
Regards,
Norman



wrote in message
oups.com...
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

On Wed, 19 Jan 2005 12:47:30 -0000, "Norman Jones"
wrote in
microsoft.public.excel.programming:

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").

wrote in message
roups.com...

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

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

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

" wrote:

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

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.

---
Regards,
Norman



"Bob Phillips" wrote in message
...
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)


"Norman Jones" wrote in message
...
Hi Johny5,

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


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


---
Regards,
Norman



wrote in message
oups.com...
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