Hi people,

I need to create a macro to generate some packing slips automatically off a BOM exported from solidworks.

I've managed to get the BOM onto my clipboard (from some code I got off this forum), but now I'm not quite sure how to go about getting it into an excel spreadsheet. Can I use excel API from the solidworks built-in VBA console?

Opinions and options would be greatly appreciated.

My goal is to run a macro that exports the bom into an excel template.

If all i need is to add a reference to excel, then some sample code would also be appreciated.

Thanks!

Cheers