Solidworks Macros Export Tabel to Excel / Import Tabel from Excel

[mhupp]

Sharing  These two VBA macros I made to help with updating tables in Solidworks. As you can use formulas to fill out or update information in excel quickly.

They are both called from the Solidworks side. 

 

Export from SW to Excel

• Checks for a Selected table in Solidworks
• Checks for excel Activeworkbook
• Checks Activeworkbook name against list of workbooks not to export to
  • Will exit if match 
• Will prompt the user if any data will be overwritten in Activeworkbook
• Each cell format is changed to text before output so excel doesn't overwrite numbers with leading 0's or other things.
• Else just outputs to active workbook with Autofit

 

Import to SW from Excel

• Checks for Excel Activeworkbook
• Takes Activeworkbook Selection and Imports to a Solid Works drawing on the right side outside of Paper Space.
• Zoom to fit after import.
• Have to move the table to import another selection or they will be on top of each other.
• what is seen excel is whats transferred. (no formulas or calculated values)
  • (cell has a number that has 4 decimal place 10.1234  but is only showing two 10.12)
  • 10.12 is what is sent to Solid Works

 

Export.swp Import.swp