Articles

object to define and execute the extrusion. Here's a basic example of how to create a simple VBA script to perform an extrusion operation in Autodesk Inventor:

VBA Programming 325 reads 0 comments Print

Call a Python function from Excel VBA

You can call a Python function from Excel VBA using the

Shell

function to execute a Python script or by using the

RunPython

method available in newer versions of Excel. Here's how you can do it using both methods:

VBA Programming 175 reads 0 comments Print

AutoCAD VBA - Insert Table

To insert a table using VBA (Visual Basic for Applications) in Excel, you can follow these steps:

VBA Programming 203 reads 0 comments Print

Index Match equivalent VBA program in Excel

In Excel, the

INDEX

and

MATCH

functions are commonly used together to perform lookups that are more flexible than

VLOOKUP

. To achieve similar functionality in VBA, you can create a custom function or use VBA code to mimic the behavior of

INDEX MATCH

. Here's how you can do it:

VBA Programming 105 reads 0 comments Print

Interact Excel and SolidWorks using VBA (Visual Basic for Applications)

To create a sample project that interacts with Excel and SolidWorks using VBA, we will cover the following steps:

VBA Programming 71 reads 0 comments Print

SolidWorks VBA Macro for Sheet Metal

Creating a VBA macro in SolidWorks for sheet metal involves automating tasks related to sheet metal parts, such as creating a sheet metal feature, flattening a part, or exporting a flat pattern. Below is a sample VBA macro that demonstrates some basic sheet metal operations in SolidWorks.

VBA Programming 105 reads 0 comments Print

Applying materials to parts in SolidWorks using VBA

Applying materials to parts in SolidWorks using VBA can be a useful way to automate the process of assigning material properties. This can help in quickly updating parts with the correct material specifications, ensuring consistency and reducing manual errors.

VBA Programming 79 reads 0 comments Print