top header
top gradation HOME top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line top vertical line menu gray
black line 2
menu gray tab More About ATI
menu blue ATI — Who We Are
white line
menu blue Contact ATI Courses
white line
menu blue List Of ATI Courses
white line
menu blue Attendees Testimonials
white line
menu blue The ATI FAQ Sheet
white line
menu blue Suggestions/Wait List
white line
menu blue New Courses
white line
menu blue Become an ATI Instructor
menu gray tab site resources
menu blue Acoustics & Sonar
white line
menu blue Rockets & Space
white line
menu blue GPS Technology
white line
menu blue ATI Blog
white line
menu blue ATI Space News
white line
menu blue ATI Site Map
white line
menu blue ATI Staff Tutorials
white line
menu blue ATI Sampler Page
white line
menu gray tab bar
menu gray tab courses
white line
menu blue Current Schedule
white line
menu blue Onsite Courses
white line
menu blue Register Online
white line
menu blue Request Brochure
white line
menu blue Free On-Site Price Quote
white line
menu blue Download Catalog
white line
menu blue Distance Learning
black line  

ATI's Solidworks/Excel Integration Using VBA-API course

Share |


    Technical Training Short On Site Course Quote

      This hands-on workshop is designed to have an immediate impact on the way that SolidWorks CAD users can integrate their CAD models with systems level analysis, trade studies, and system level optimization. Excel Spreadsheets are utilized as the system level tool integration platform. The underlying key to implementing this process is for the user to gain experience and knowledge on the use of Visual Basic for Applications (VBA) in both Excel and SolidWorks. Extensive use of VBA is the key to unlocking all the features of SolidWorks and reducing the amount of tedious work. This provides the ability to move away from the CAD interface to the more familiar Excel application. Those who attend this intensive hands-on workshop experience a dramatic change in their use of SolidWorks in the design integration process. Benefits include increased productivity, automation of tedious tasks, SolidWorks’ part and assemblies automation, development functions, forms and templates, improved documentation and configuration management, and improved team interaction and parameter sharing.

      Each participant receives a 3-volume set of workshop notes which include all the PowerPoint slides used during the workshop for concept discussion and setting up of workshop exercises. The CD-ROM contains an electronic version of the course notes; the workshop examples; and selected SpreadsheetWorld Engineering XLToolboxes. Workshop attendees receive free updates on selected software for 5 years. Participants also receive a copy of Computational VBA, which is written by SpreadsheetWorld.



      Chris Stimson, M.S., Project Engineer, Moog, Inc. Chatsworth, CA , SolidWorks/Excel Applications Specialist, SpreadsheetWorld, Inc. and is an instructor at California State University Northridge (CSUN). Mr. Stimson is a pioneer in the integration of Excel and SolidWorks using the VBA Application Programming Interface (API). At Moog, he oversees the development of Moog's space components product line. He teaches an advanced design integration graduate course at CSUN which includes topics taught this workshop. He received his Master’s Degree in Mechanical Engineering at CSUN, where his Master’s Project focused on “Automation of the CAD Design of a positive Displacement Pump” using the integration of SolidWorks and Excel. In his project, he developed the concept of using the Excel platform to command, control and communicate design parameters to Excel.

      Contact this instructor (please mention course name in the subject line)

    Who Should Attend:

      This workshop requires advance knowledge of SolidWorks and Excel VBA. Design engineers using CAD programs find these courses immediately useful, practical and eye-opening. Participants should have a computer background including basic keyboard and Excel skills.

    Course Outline:

      Overview of SolidWorks Environment

      • SolidWorks API Overview

      • SolidWorks VBA Menu

      • SolidWorks Macros and Microsoft VBA Overview

      • SolidWorks API Standalone and Add-in Applications Overview

      • SolidWorks API Object Model Overview

      • ModelDoc2 Object

      • OLE applications

      • PartDoc Object

      • AssemblyDoc Object

      • DrawingDoc Object

      Overview of ExcelTM Environment

      • The central role of VBA in Excel

      • The Excel VBA application object library

      • Excel menus and toolbar objects

      • Setting application level preferences

      • Forms for simple worksheet user interface

      • Using the VBA Recorder

      Visual Basic for Applications (VBA)

      • Objects

      • Properties

      • Methods

      • Events

      • Procedure

      • Data Types

      • Option Explicit

      • Overview of VBA Editor Windows

      • debugging

      • VBA Statements

      • Data Properties

      • CreateObject function

      • Array Function

      • String Concatenation

      • Loops

      • InputBox and Message Box Functions

      Using the SolidWorks Macro Recorder

      • Marco Recorder Introduction

      • Marco Tool Bar

      • Cylinder Example

      • Run SolidWorks Macro

      • Edit or Debug SolidWorks Macro

      • Assign SolidWorks Macro to Button

      • Assign SolidWorks Macro to Shortcut Key

      • Angle Bracket Example

      Assigning Material Properties

      • Example 1: Assigning Materials Properties to Parts

      • Example 2: Assigning Material Properties to Assemblies

      • Example 3: Materials Editor PropertyManager

      Model Dimension using Excel VBA

      • Section Overview

      • Cylinder Example

      • Box Assembly Example

      Custom Properties

      • Summary information

      • Setting Properties

      • Modifing Properties

      • Add and Delete Properties

      Importing Data From Excel or a Text File

      • Working with Excel

      • 3Dcurves

      Automating the Solid Model Process

      • Creating a model

      • User - forms

      Model Editing

      • Editing a Part Document with Known Features

      • Traversal Editing

      Drawing Automation

      • Introduction

      • Creating Drawings

      • Accessing Directory Information


      Tuition for this three-day course is $1845 per person at one of our scheduled public courses. Onsite pricing is available. Please call us at 410-956-8805 or send an email to

    Register Now Without Obligation