Visual Basic Scripts

[divisionary1]

Hello,

 

I have a Visual Basic question...

 

Is it possible to run a MasterCAM VB Script from an EXCEL VBA module?

(Assuming the SHELL Function was already executed in this VBA module to open MasterCAM)

 

My initial goal was to automate the "Create library from text" translation from an Excel generated comma delimited (.csv) file. I can now do this manually. I’ve learned that "Create library from text" is not possible via VB Script per Version 9.1. [searched Topic: VBScript and access to Tool library] Looking forward to Version 10!!

 

In the mean time, there are other VB Script functions that I would like to automate (i.e.. AutoDesk: Read File) from a VBA Module. Please Help.

 

Also, I am very interested in learning more about writing VB Scripts in MasterCAM. Are there any great websites, forums, books or other help on writing MC-VBS?? More Sample Code??

 

Thank You

[Mick from CNC Software Inc.]

Divisionary

 

You can call a VBScript from a commandline for example;

 

code:

---

C:Mcam9ROUTER9.EXE ASKLEVEL.VBS

---

The above would automatically execute the script ASKLEVEL.VBS, therefore if you are shelling out from VBA you should be able to launch a script.

 

The Mastercam VBScript Editor help file has a lot of links to scripting resources online, also a search of these forums for the words vb script will return plenty of hits with lots of examples users here have submitted.

[Bullines]

Mick would be able to answer this better, but...

 

AFAIK, Mastercam cannot be automated from external apps because none of its functionality is exposed via something like COM. You can, however, automate Excel from Mastercam. HTH.

[divisionary1]

Thanks Mick

Thanks Bullines!

 

was using: SHELL("C:MCAM9FILENAME.MC9 SCRIPT.VBS")

now using: SHELL("C:MCAM9MILL9.EXE FILENAME.MC9 SCRIPT.VBS")

 

Works Great!! Thanks Again for the Tip!!!

 

Divisionary