• This comprehensive course provides a foundational understanding of Visual Basic for Applications (VBA) and its seamless integration with SOLIDWORKS. It’s designed for individuals seeking to automate tasks within the SOLIDWORKS environment, enhancing productivity and efficiency.

This course is for:

• SOLIDWORKS Design Engineers / Drafters
• University students in STEM fields.
•  Developers learning about SOLIDWORKS automation

Course Details:

• 10 HOURS of instruction time.
• Hands-on teaching style.
• Fixed-price course available in perpetuity.
• Achievement certificate when you finish the course.

System Requirements:

• Windows 7, 8, 10 or 11.
• SOLIDWORKS 3D Desktop (Student, Standard, Professional, Premium) or;
• SOLIDWORKS Connected.
• VBA component installed with SOLIDWORKS.

Material:

• Sample files are in SW 2017—instructor using SOLIDWORKS 2023.

Overall Objectives:

This course equips learners with the necessary knowledge and skills to:

• Automate repetitive tasks within the SOLIDWORKS environment, significantly improving productivity and efficiency.
• Develop custom VBA macros to streamline complex design processes.
• Enhance the functionality of SOLIDWORKS through custom user interfaces and tools.
• Gain a deeper understanding of the SOLIDWORKS API and its capabilities.
• Write robust, maintainable, and error-free VBA code.
• Become proficient in automating various aspects of the SOLIDWORKS design process, including part modeling, assembly, and drawing creation.

Core Concepts:

• VBA Fundamentals:
  • Introduction: History, evolution, and diverse applications of VBA across various fields.
  • Macro Recorder: Practical guidance on utilizing the macro recorder to automate repetitive tasks and subsequently adding custom buttons to the SOLIDWORKS user interface for easy access.
  • VBA Editor: Navigating the VBA editor interface, understanding its workspace, and customizing it for optimal workflow.
  • Programming Basics: Essential programming concepts, including variables, data types, and control structures (if statements, loops, operators, and expressions).
  • Subroutines & Functions: Defining and utilizing subroutines and functions within the VBA environment.
  • Data Structures: Exploring various data structures available in VBA to organize and manage data effectively.
  • Modules & Classes: Understanding the distinction between standard modules and class modules, and their respective roles in VBA development.
  • Code Quality: Emphasizing the importance of writing clean, maintainable code through proper naming conventions, comprehensive code comments, and thorough documentation.
  • Debugging: Identifying and resolving common errors in VBA code using debugging tools and techniques.
  • Error Handling: Implementing robust error handling techniques to prevent unexpected program failures and ensure code stability.
  • Option Explicit: Understanding the significance of Option Explicit in enforcing variable declaration and improving code reliability.
  • Events: Learning how to create and utilize events within the VBA environment to trigger specific actions.
  • User Forms: Designing and creating user forms with interactive elements (buttons, text boxes, etc.) to enhance user interaction with VBA applications.
• SOLIDWORKS API:
  • API Documentation: Comparing offline and online API documentation and mastering the navigation of offline documentation for efficient reference.
  • SldWorks Interface: Gaining a thorough understanding of the SldWorks interface, its key features, and functionalities.
  • Common Functionalities: Mastering essential API functionalities:
    • Opening, activating, and closing SOLIDWORKS documents.
    • Accessing and modifying system options and document properties.
    • Managing custom properties at both document and configuration levels.
    • Navigating and manipulating the feature manager tree.
    • Utilizing the selection manager to efficiently select and interact with objects within the SOLIDWORKS environment (e.g., GetSelectedObject, GetSelectedObjectType, GetSelectedObjectCount).
    • Working with configurations, including listing, creating, activating, and deleting configurations.
    • Creating new documents using templates.
    • Parts Automation:
      • Accessing and manipulating bodies.
      • Traversing the geometry tree (entities, faces, edges, vertices).
      • Creating and editing references (e.g., reference planes).
      • Sketching and utilizing sketches for operations like extrusion and cutting.
      • Suppressing features.
    • Assembly Automation:
      • Traversing the assembly component tree.
      • Working with referenced configurations within components.
      • Inserting components within assemblies.
      • Advanced selection techniques for creating mates.
      • Mating components using the API.
    • Drawing Automation:
      • Creating drawings with pre-defined views.
      • Generating Bills of Materials (BOM) tables.
      • Traversing drawing annotations.
  • Mini-Project:
    • DXF Exporter for sheet metal parts in an assembly