I am submitting data to an excel spreadsheet from VB and it takes time to complete after clikcing on the cmdSubmit

I placed a progress bar to show the progress ...

This is what happens:

I click on the command button and then the hour glass appears (at this time, I want my progress bar to be working) once the hour glass vanishes the progress bar will run..

Can anyone please help me????


Steve