vba

You can extract the data from an excel file (without opening it) and use it inside an AutoCAD file for drawing objects;

This is just an example on How to use the data from Excel Cells inside the CAD drawing to Automate the Autocad drawing process.

Don't forget to add Microsoft Excel Object Libraries (Tools->References) [AutoCAD VBA Editor]

Record a Solidworks macro

In this example we will discuss about “How to Record a Macro in Solidworks”

Open the Solidworks, Go to Tools -> Macro -> Record

Then start your project, in this example we will be making a cylinder (Draw circle and extrude it to Cylinder)

Create a New Part Document