Как сохранить файл solidworks в exe

If you are wondering how to export a SolidWorks type BOM to Excel, then you have come to the right place.

I have looked all over the internet and could not find the solution I was looking for, so I decided to create a macro myself to do this.

You can view each procedure/function individually by clicking the panel headers below the video

or watch the video now.

Please click on the panels below to reveal or hide the macro code

Sub main() Procedure

In the Sub Main() you can either let the macro traverse the Feature Tree to find a BOM, or you can select it manually by clicking a BOM in the Feature Tree.

If you let the macro traverse then in the Sub TraverseFeatureTree() then rename the feature that you are looking for.

The BOM that I am looking for is called BillofMaterials2

I used the SaveAsText function, which allows you to save it as a .csv file. If you use this function and save it as an .xls file, then when you try to open it it come up with a message box. So this way it by-passes the pop up message box. It is fully automated this way.

In the Sub TraverseFeatureTree() change the feature that you are looking for. In the code below, where it says Bill of Materials2, change it to what ever the name of your BOM is.

By doing this it will fully automate the process with out you or the user having to select it manually in the Feature Tree.

Once the BOM is captured then it is on to the RenameBomToCSV() function.

This function basically takes the path of the active document (the drawing) and removes the SolidWorks file extension (.slddrw) and adds the .csv file extension. I have done it this way so that eventually when the BOM is finally saved as an Excel file, it will be in the same folder where your SolidWorks drawing is saved. Hope that make sense.

The Sub SaveCSVAsXLS speaks for itself. It has one argument passed in, which is the csv file.

If you have already run the macro then this function will delete the Excel file that is already there.

The reason for this is so that a message box does not pop up asking do you want to save over an existing file.

You can delete the lines where it says Kill FileToKill if you dont mind a message box popping up.

How can i export solidworks data to excel?

I am trying to export solidworks data and make a list of dimensions on a chasis project. I remember people was able to export those data to microsoft excel and then revision/update the model from excel.

Is that really possible and how? or do i remember wrong?

(solidworks 2012, MS Office 2010)

2 Answers

InspectionXpert for SolidWorks exports dimensions and tolerances from SolidWorks drawings. It balloons the dimensions on the drawing too so that you can match up the dimensions on the drawing with those in Excel.

Сохранение деталей и сборок из SolidWorks в файл .exe

Всем привет! Сегодня мы разберём как сборку или деталь в SolidWorks сохранить в файл с расширением .exe.

Это может понадобиться для передачи файлов 3d моделей, которые мы создали в SolidWorks, людям для просмотра и оценке конструкции сборки. При этом им не нужно будет устанавливать сам SolidWorks и любой дополнительный софт, что, согласитесь, очень удобно!

Переходим непосредственно к сохранению, для этого берем и открываем сборку кривошипно-коромыслового механизма, созданного в уроках: Создание сборки в Solidworks, Сборка кривошипно-коромыслового механизма в SolidWorks.