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

Summary: 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. Instructor: 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. 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: Tuition for this three-day course is $1795 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 ati@ATIcourses.com. Register Now Without Obligation