Other Microsoft VBA-enabled Applications
Because Microsoft VBA is embedded in the SolidWorks software, the SolidWorks
software is VBA-enabled and can inter-operate with other VBA-enabled applications,
such as Microsoft Excel, Microsoft Access, and Microsoft Visio.
For example, you can create a VBA application in the SolidWorks software
that attaches to a running instance of Microsoft Excel. You can then access
the active sheet and retrieve data to use with the SolidWorks software.
The following code shows how to attach to the active Microsoft Excel
object, get the value in cell A1 in the active sheet, and use that value
to set the density in a SolidWorks part.
' Attach to active Excel object
Set xl = GetObject(, "Excel.Application")
' Get active
sheet in Excel
Set xlsh = xl.ActiveSheet
' Get value
in Excel cell A1
density = xlsh.Cells(1,1)
' Set density
in SolidWorks part
Alternatively you can also attach to a running instance of the SolidWorks
software from a VBA application created in Microsoft Excel.
In general, if your application is primarily a SolidWorks API application,
then develop the application in the SolidWorks software.