Hello Guest it is March 28, 2024, 08:09:21 PM

Author Topic: Controlling Mach3 using a VBA macro in MS Excel  (Read 4426 times)

0 Members and 1 Guest are viewing this topic.

Controlling Mach3 using a VBA macro in MS Excel
« on: November 05, 2010, 11:58:53 AM »
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?
Re: Controlling Mach3 using a VBA macro in MS Excel
« Reply #1 on: November 08, 2010, 05:46:19 PM »
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.
Re: Controlling Mach3 using a VBA macro in MS Excel
« Reply #2 on: November 09, 2010, 06:00:40 PM »
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.