msgbox function

[ngerman01]

I need to run a macro out of excel that will open a labeling program and then have a message box appear in the labeling program. Also on a side note is there a way to pause vba code for a set amount of time without pause the rest of the computer. I have tried using Application.Wait, but that pause everything else too.

Thanks

 

[VBAjedi]

What is the "Labelling program" you want to run? Is it a VBA sub or a standalone application? If it's in VBA the messagebox should be straightforward, but making a box appear in a standalone app may be difficult or impossible.

Regarding the pause issue: try adding a DoEvents command after a short Application.Wait, and looping them a handful of times. Also read what the help files have to say about the OnTime method.

VBAjedi

 

[Muzzery]

Try this code for getting the code to Wait, it's just a timer that waite for 5 seconds, then carrys on the code.

Private Sub Wait_Click()
Dim tTarget As Date
              
    tTarget = Timer + 5
    Do Until Timer > tTarget
    Loop
    MsgBox "5 Seconds up"
End Sub

 

[ETID]

Are you using the "SHELL" command ?

 

[ngerman01]

Yes to open the program the shell command is being used

 

[ETID]

Then this FAQ should help you plenty...

faq707-2542

enjoy

 

[ngerman01]

Also the I am not sure about the if the labeling program is VBA sub. I was told that it was activeX aware, but not really knowing what that means it did not help me. The labeling program itself contains a VBA editor.

 

[ETID]

Did you check out the FAQ?

 

[ngerman01]

yes i checked out the faq but the place that i want the program to pause is further down the line from the
shell(ing).

 

[ETID]

then the on time event is what you need...

as muzzery illustrated above

 

[ETID]

Unless your inadvertenly calling a vba function in your shelled process....

then that compounds the problem...

I don't believe that two instances of the vba interpreter will run at the same time.

So you might be forced to add a module to the shelled applications vba function.