Hide Table of Contents

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

Part.SetUserPreferenceDoubleValue swMaterialPropertyDensity, density  

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.



Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

 
*Email:  
Subject:   Feedback on Help Topics
Page:   Other Microsoft VBA-enabled Applications
*Comment:  
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:



x

We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again
x

Web Help Content Version: API Help (English only) 2018 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.