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.