How to show than a macro is running and didn't crash ?

[Dina3419]

Hello everybody,

I created a VBA macro with CATIA V5 which can run during 30 min.
The problem is that nothing moves and half the time the screen is white so the user thinks the macro crashed.

I'd like to add something showing the macro is still working.
I used a label in a progressbar, the label's widht increases thanks to a timer, but this works only AFTER the macro's done.

Do you know how I could make this work in the same time than the macro ? Or anybody has an other idea ?

Thanks in advance,

Dina

 

[ferdo]

Hi,


Try to run it in batch mode with a final message of job done if your computer is able to cover 2 CATIA processes.

Regards
Fernando

 

[brengine]

I've used the ProgressBar and a periodic 'DoEvents' to update the status message.

If that doesn't work (i.e. screen still white), you can try making a small form with a message like 'Macro Still Running. Please Wait...' or something like that. When you show it use:

frmStatus.Show vbModeless

You'll probably need to do a periodic 'DoEvents' for this as well.

Change the Message to 'Done!' when macro complete.