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

Thomas

Active Member
Joined
May 3, 2002
Messages
366
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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
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

Active Member
Joined
May 3, 2002
Messages
366
:( Ah Well.. it was worth a try.

Thanks for the response!

- Thomas
 

Forum statistics

Threads
1,144,148
Messages
5,722,776
Members
422,457
Latest member
Mrmuskins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top