AnsweredAssumed Answered

Use Excel API from Solidworks VBA

Question asked by Filipe Venceslau on Apr 9, 2010
Latest reply on Apr 9, 2010 by Filipe Venceslau

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.