Inserting an excell spreadsheet

[smoa1980]

I have a spreadaheet with a bunch of x,y,z locations, and I want to import them to mastercam as points. I have Version 9, and have looked in the help but did not find what I was looking for. Any suggestions?

[Alex_Cole]

I sent you a pm

[Salty72]

this is alss of intrest to me, as I have a gear cuting program that is written in excel and also generates three seperate X, Y, and Z co-ords I use the excel feature concatinate to form a string and then save as text file but importing to MC9 or McX is my problem - will MC allow the import of G-code and then redraw images etc..

cheers in advance

Salty

[Alex_Cole]

I will not really read in a text file per say but if the files are in a specific format in excell then you could access them and create geometry based on that using vbscript. in mastercam 9 and older do "alt c" to get to the chooks...then select the mcamvb.dll file ..this will open a bar that allows you to run, open and edit vbscripts. look through the samples that are installed. There is one called excell somthing. I think that might help you the most. post one of your files and someone here might be able to help more.

ac

[Salty72]

I can do better than that here is the gear program

[Rekd]

I will not really read in a text file per say but if the files are in a specific format in excell then you could access them and create geometry based on that using vbscript. in mastercam 9 and older do "alt c" to get to the chooks...then select the mcamvb.dll file ..this will open a bar that allows you to run, open and edit vbscripts. look through the samples that are installed. There is one called excell somthing. I think that might help you the most. post one of your files and someone here might be able to help more.

ac

Actually, the vb scripting didn't exist until MC version 9.1. v9.0 and lower won't have it.

[Salty72]

I think I made a Boo Boo... I have just checked the *.zip I posted earlier and it's not the program I used .. HOWEVER I noticed that it does generate its own G-Gode so it will solve my problem...

salty

[Alex_Cole]

sorry for the confusion my reference to v9 and older was to how to access where the chooks are. I guess I didn't word it to well. I was not trying to imply that vbs was available in versions prior to 9. I was just trying to point out how to get to it in 9 because it is in a different spot in x.

thanks for catching my slip rekd

ac

[Mike Mattera]

I know there is a VB script for reading an excel SSheet. Mick at CNC wrote it for me to do a Cam for one of my customers. After that it ended up in the folder with all the other VBS's. Has to be 9.1 sp2 or newer I think.

Mike Mattera

[smoa1980]

mike you are right, after diggin a little there is a file built in to do it. You use mcamvb.dll, as stated by alex. Then there is a file to do it. I can't remeber what it is called because I did it at work and the name slips my mind. But it puts the points up and connected them with lines.

[Mike Mattera]

cam.vb If you cant find it, send me an email. I have a copy somewhere.

Mike