I don't know if the Microsoft version matters or not. I am also concerned about making using a Macro to make things easier and faster after linking SW BOM to Excel.
You can save out a SW BOM as an Excel file, but as far as I know it loses connectivity, so if the Assembly is edited the Excel BOM wouldn't update and a new one would need to be saved.
thanks for the reply but i managed to make a link between the assembly parts to be automated directly to the 2D of solidworks.
Retrieving data ...