HI all,

we have just stared to use the Excel Based BOM function in Solidworks 2014. This solves a load of issues for us and is actually useful.

I was wondering how to create a macro to save the bom to a specific folder on out network. Ive tried running the macro recorder but it doesn't make any sense

<p>Dim swApp As Object</p><p>Dim Part As Object<br>Dim boolstatus As Boolean<br>Dim longstatus As Long, longwarnings As Long</p><p>Sub main()</p><p>Set swApp = _<br>Application.SldWorks</p><p>Set Part = swApp.ActiveDoc<br>boolstatus = Part.Extension.SelectByID2("@Drawing View1", "BOM", 9.80850184849844E-02, 0.344196913033501, 0, False, 0, Nothing, 0)<br>End Sub</p>

I would like to just click a macro and it save to my e:\\documents\\BOM\\ folder with the document name and the version number if possible.

I would appreciate some help with this please.

Thanks in advance

Mark