Userform Statusbar while saving (link somehow to Excel's Sta

[Thomas]

I'm so close to finishing this project....*whew!*. Here's the last thing:

At the closeout of the book, there is an auto-save that occurs. Unfortunately, the file is rather large and is being saved to a public server, so savetime averages about a minute or so. I need a Userform to pop up and show %complete of save, so that other people using this will not just shut down the Application, thinking it is hung (many of them won't really know to look down at the status bar, you know? :wink: ).

Is there a way to possibly tap into Excel's Status bar, and get the percent saved from it? I know that while saving, it shows a little bar that fills up as the save completes. It would be handy to be able to read this value in real-time, and allow a Userform/status bar to read it ~during~ the save.

Any suggestions?

Thanks in advance!
- Thomas

 

[Juan Pablo González]

From what I know, you can't trap that. That is one instruction in a macro, i.e,

ThisWorkbook.Save

and Excel (Well VBA) won't continue with the macro until this has ended. So, you would have to show the userform as "Please wait, I'm saving...", but, progress bar... I don't think it's doable.

 

[Thomas]

Ah Well.. it was worth a try.

Thanks for the response!

- Thomas