PDA

View Full Version : Progress Bar



av8tordude
08-27-2009, 09:15 AM
I have a file that takes approximately 5-10 secs to save. Is it possible to display a progress bar to represent how much time is left until the file is saved?

D_Rennie
08-27-2009, 09:28 AM
To my knowledge progress bars are done withen loops or large amounts of code.
And if its only a few seconds there realy is not any point.
Reserve the use of a progress bar for when a routine will take 30min +
All the best

av8tordude
08-27-2009, 01:57 PM
To my knowledge progress bars are done withen loops or large amounts of code.
And if its only a few seconds there realy is not any point.
Reserve the use of a progress bar for when a routine will take 30min +
All the best

Forgive my ignorance, but if I click the save button or have it automatically saved when I close the file, how do call the progress bar. by the way, When I started with a file with very little data, it was a non-issue, but as I have added a lot more data to the file, the save time has gotten longer and longer. So as of now, it takes 20-25 seconds to save.

D_Rennie
08-27-2009, 04:47 PM
im guessing that your save procudure is made up of one or two lines.
IMO forget about the progress bar. There is not enough code to make it worth while. Or the code structure is not suited for a progress bar.

Someone may prove me wrong though.

tpoynton
08-27-2009, 05:28 PM
my method is to show a modeless userform before the save saying 'be patient', then after the save statement unload it. This assumes the save is being done through code.

There's nothing to track the progress of the save that I'm aware of, so using a progress bar is not possible.