Running a LISP routine from VBA

[cheeseed]

My title is kind of misleading. I know how to use SendCommand to run a LISP routine from a VBA program.

My problem is that I want the LISP routine to execute and then have additional VBA code run when it's done. The code I have written starts the LISP routine and then continues executing the remaining lines of VBA code. As a result, the entire VBA program executes and then the user is allowed to finish the LISP routine.

What do I do to get the VBA program to "wait" for the LISP to finish before continuing?

[TCARPENTER]

Hi cheeseed,

Try this after your SendCommand:

DoEvents

Sometimes this is a little quirky and doesn't always perform like you'd expect but give it a try.

HTH
Todd