![automating solidworks with excel automating solidworks with excel](https://blogs.solidworks.com/solidworksblog/wp-content/uploads/sites/2/2020/09/render20061220202001.jpg)
User only needs to select the product number and enter data in Excel rows such as require dimensions, end client data, project name, option for generate DXFs and Revisions etc.Solidworks Automation using Excel Add in - YouTube. Excel GetObject(, 'Excel.Application') swDoc swApp.ActiveDoc 3DSketch(True) Dim skPoint As SketchPoint Nothing swDoc. Some can only be used for sheet metal or weldment bodies. All the design specifications received from the end-user will be fetched from the CAD library and opened in SolidWorks. Automating SOLIDWORKS 2019 Using Macros is designed as a tutorial to help beginner to intermediate. Custom properties automation is one of the most demanding parts of SOLIDWORKS API.The user can enter custom specifications in the master Excel sheet which is in turn connected to SolidWorks with VBA API.Primary investigation led the project team to advice manufacturer to create an Excel based configurator for implementing automation at various stages of design and modelling.Automation team working on the project initially studied the SolidWorks models and drawings shared by the client to identify the scope for automation. Owing to our strong pre-existing portfolio in the domain, Australia based manufacturing firm approached Hitech teams to develop an automation tool and reduce design cycle time.