I have created a macro that will export a SolidWorks type BOM in a drawing as an .xls file. I actually looked all over the internet and forums, but found nothing exactly as I wanted. So I came up with this.

You can either manually select a BOM in the feature tree or hard code the macro to look for a BOM by traversing the feature tree. It will then save it off as a .csv file which will then be saved off as an .xls file into the same folder as the drawing. If you use the .SaveAsText function to save it as an .xls file you will get a message saying that it is a text file when you open it. I wanted to avoid this and make it fully automated.

Hope this helps

Here is the link

export solidworks bom to excel