How to write VBS to scan the excel data and create a spline inside the mastercamX2

[pohyg]

Hello all,

I am doing a cam profile which base on data given by a excel file format.

For my intention i hope can write a VBS to read

all data for the excel file and convert it to a spline inside mastercam.

Because i can't find spline command inside mastercam VBS help and how to use the mastercam command "create_spline_points" in VBS to scan all the excel file data and output to a spline entity .

Note: Mastercam X2 open file can read ASCll (.TXT) and convert it to a spline but it need to do few step from excel file to done the job.

Thank you

Best Regards

Pohyg

[Roger Martin from CNC Software]

Pohyg,

 

I don't believe that there is a way using VB Script to create a spline in Mastercam (x2).

 

"Mastercam X2 open file can read ASCll (.TXT) and convert it to a spline but it need to do few step from excel file to done the job."

 

Questions:

1> What steps are needed, other than creating the CSV file from the data in your Excel sheet?

2> Is this point data for CAM profiles?

[pohyg]

1> Yes Roger Martin I need to write some formula to calculate the x and y value for the point .If I can scan the data for excel sheet and write the formula inside VBS to generate the point . Because the cam data on the excel sheet was base on every 0.1 degree angle and given a radius , so i need to use Tan?= o/j or

COS ? = h/j or sin?= o/h to output the X, y value for the points to create the spline.

2> Is possible use the mastercam command in VBS to scan and use the formular to output the spline entity

Thank you

[Roger Martin from CNC Software]

pohyg ,

 

It sounds like you have point data in a 'Polar' (angle and distance) format. Correct?

 

Could you email a sample XLS you are wanting to process? (Click on the mail icon at the top of this posting)

 

What is the (exact) version of Mastercam you are running?

[pohyg]

Hello Roger Martin,

Yes you are right data in excel sheet are polar angle and distance .

 

but I hope can write a VBS to calculate all the point and general out all the points inside the mastercam

and convert it to a spline.

Can I use the mastercam command for example the at the VBS to draw the Spline.

currently I was using Mcam X2 MR1 SP1 and

this is my interest to learn how to write the VBS for the CAM profile

and to go one step forward to explore the function of VBS in mastercam.

 

I had E-mail the example excel data to you

 

please let me know went you are received .

 

Thank you

Best regards

Pohyg

[Roger Martin from CNC Software]

pohyg,

 

Check you email.

Hopefully this will get you started.

 

I am certainly not an expert at the VB Scripting.

Luckily the requested task was not too difficult.

 

Note that the VBS only creats Points, as there is no way to create Splines using the Mastercam VBS.

[pohyg]

Reger Martin,

 

Thank you for VBS I will send my VBS to you that I was modify from the MC9 example and I was Some question , how to set the below value at my VBS .

 

SetLevelVisibleByNumber(10) ' poh addin ??

Bool False ' poh addin ??

 

Note: Below was mastercam VBS Help example

 

// set the named level visible by entering its name

 

Bool SetLevelVisibleByName (

 

String (Input: name of level)

 

Bool (Input: True = show/ False = hide)

 

)

Thank you

 

pohyg