×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

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

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

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:

CODE

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources