How to show than a macro is running and didn't crash ?
How to show than a macro is running and didn't crash ?
(OP)
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
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





RE: How to show than a macro is running and didn't crash ?
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
RE: How to show than a macro is running and didn't crash ?
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:
CODE
Change the Message to 'Done!' when macro complete.