Saving Workbook

[AlexanderBB]

I'd like to save my workbook from VBA and show a non-modal Form
saying the Save is happening. I think that bits easy, but I'd like
the Form to automatically unload when the Save is complete. The non-model
Form is to prevent anything else happening while the Save is ocurring.

Is it possible to do this and is my logic OK ?

Thanks, ABB

 

[tusharm]

Nothing can happen while Excel is saving the workbook. So, no need to worry about the form. Maybe, the untested

UF.show false
WB.Save
UF.hide

I'd like to save my workbook from VBA and show a non-modal Form
saying the Save is happening. I think that bits easy, but I'd like
the Form to automatically unload when the Save is complete. The non-model
Form is to prevent anything else happening while the Save is ocurring.

Is it possible to do this and is my logic OK ?

Thanks, ABB

 

[AlexanderBB]

Yes maybe... like to test but I get 'Variable not defined' in WB.Save
I guess you've abbreviated it, but I don't know the correct syntax.

 

[AlexanderBB]

tusharm, thanks! That was much easier than expected and works a treat!</pre>

 

[tusharm]

You are welcome. Simple and easy is usually the way to go. {grin}

tusharm, thanks! That was much easier than expected and works a treat!</pre>