export tool data to excel table

export tool data to excel table

roberto_perez
Contributor Contributor
897 Views
4 Replies
Message 1 of 5

export tool data to excel table

roberto_perez
Contributor
Contributor

good morning
I have a macro that is used to import into powermill a list of tools that has previously been filled in in an excel table. This table is made up of all the data that the tool needs to have the different components, reference, family, tip data, shank and even cutting conditions.

If someone had the same thing but in reverse, I would need a macro to export all the data that makes up this tool to Excel. please look at the table to understand.
attached example table and macro

 

123.JPG

 


Thank you

0 Likes
898 Views
4 Replies
Replies (4)
Message 2 of 5

kevin.hammond3WX4X
Advocate
Advocate

Hi, i don't have the time to give you all that you are asking for, but see the attached file, this will get you started.

Hope this helps.

Please share your final macro, as it may be of use to others.

Regards Kevin

0 Likes
Message 3 of 5

roberto_perez
Contributor
Contributor

hello. unfortunately I have no programming knowledge, I would gladly share it with all members, but I don't know how to do it

Thank you

0 Likes
Message 4 of 5

Michaelangelo631
Advocate
Advocate

@Anonymousposted about a  macro that will export all your tool info as a text file.  If you import this into excel with some formatting you can get close to what you are looking for.  This is not a full solution but a partial step in the right direction.

 

https://forums.autodesk.com/t5/powermill-forum/export-tool-database-in-csv/td-p/9289962

 

Regards,

Mike

0 Likes
Message 5 of 5

roberto_perez
Contributor
Contributor

@Michaelangelo631 

 

Thanks, I was looking at it but it doesn't get all the component fields

0 Likes