Progress indicator while saving a file.

  • Thread starter Thread starter PCLIVE
  • Start date Start date
P

PCLIVE

Hi.

I'm using VB code to save my Excel file to an off-site server. This saving
process can take as much as a minute. During this time, it is hard to tell
that anything is happening. I was wondering if there was a way to have some
sort of progress indicator display while the file is being saved.

Thanks.
 
Assuming you are doing something like:
Thisworkbook.saveas Filename
you only a one line call, so you get no indication of progress to react to.
You can use:
Application.Cursor = xlWait
Application.StatusBar="Saving..."
Thisworkbook.saveas Filename
Application.Cursor = xlDefault
Application.StatusBar=fasle

to give a visual clue to the user that something is happening.

If you are using another method, then post your code.

NickHK
 
NickHK,

I'm already utilizing the Application.StatusBar code. I will apply the
Application.Cursor code. That may be just enough to do what I need.

Thanks.
Paul
 
Back
Top