Controlling Mach3 using a VBA macro in MS Excel

[Armando]

I've been working with Mach3 for the past couple months on a WR-203 CNC router. Lately, I've been trying to integrate Mach3 with an VBA macro in MS Excel, but have been running into trouble trying to get them to mesh. All I'm trying to do is control the movement of the "spindle" (I've actually replaced the spindle with an infrared camera, long story) in the x-, y-, and z-directions.

Is it possible to control Mach3 through a VBA macro?

[Armando]

I guess what I'm wondering is if anyone knows of any .olb or .dll files that can be referenced and used to control Mach3 through Excel VBA.

[Armando]

I checked out a couple other posts and saw that many have basically just been using VBScript to either generate a G-code program or use SendKeys to send coordinates to MDI. It doesn't seem ideal, but, if it works, it works.

I've written a simple script in VBS that seems to do the trick, and I've figured out how to run it from Excel VBA. What I'll probably be doing for the rest of the week is trying to do something like what I've been doing in VBScript (using SendKeys) in VBA, so we'll see what happens.