Progress Bar

[KevinFSI]

I posted this in a VBA-for-Access thread. I think this thread would be more appropriate.

I've designed a progress bar that shows the user the progress of the macro they're running. It works really well, but I have one question:

The last step in the macro is to save the active Excel workbook. Is there a way to incorporate that into my progress bar? Of course it shows up in the status bar at the bottom, so I should probably quit while I'm ahead on this particular project, but I'm dying to know if this can be done.

How does the old saying go? "If it ain't broke, don't fix it!"

Thanks in advance, Kevin
slanek@ssd.fsi.com

 

[cLocKwOrkPRO]

Why not just create a Sub that is called saveWorkbook in the module your Macro is in. Then put your code for saving in there. Then once the progress bar finshes you can call, for example, module1.saveWorkbook.

-cLocKwOrkPRO

 

[KevinFSI]

I'm already doing that. What I wanted was a way to show the progress of the save operation in the progress bar. Kevin
slanek@ssd.fsi.com

 

[wkrupinsky]

Kevin - I am very interested in your progress bar that shows percentage complete of a macro being run. Could you possibly supply the code you use for this to happen?

Thanks

 

[kylua]

If you timed the length of time it takes to save, you could use a timer function to show it. I believe this uses a separate thread to whatever macro is running and will run concurrent to the saving process.