Select Page

Using MS-Excel as a configurator within SolidWorks Electrical

SolidWorks Electrical can create schematic project content based on entries from an MS-Excel worksheet. The worksheet contains pointers to SolidWorks Electrical macros (not to be confused with MS-Excel VBA macros). These macros will be inserted in the project using values specified in the MS-Excel worksheet.

SolidWorks Electrical reads the first worksheet in the MS-Excel file so it is possible to add a user interface and customisation in other sheets within the MS-Excel file that will automatically populate the first worksheet so the system can be driven using a friendly non-technical user interface.

Throughout the course of this 20 minute webcast we will look at;

  • How to create a SolidWorks Electrical macro?
  • How to create and edit the MS-Excel input file?
  • Using variables in your SolidWorks Electrical macros.
  • Adding automation to your MS-Excel file.

This webcast is suitable for those who have been trained or are competent SolidWorks Electrical users and are reasonably competent with editing MS-Excel files.

SolidWorks Electrical ERP Database Connections

When using SolidWorks Electrical and selecting manufacturer parts to use within the design, there are often many parts to choose from.

You can set up a link within SolidWorks Electrical that will enable you to query other databases on the network for ERP/MRP attributes such as stock levels or costs of specific parts to help assist the Engineer in choosing the best part to use for a specific job.

Throughout the course of this 20 minute webcast we will look at;

  • The type of database that can be connected to.
  • How to connect SolidWorks Electrical to the ERP/MRP database.
  • Querying ERP/MRP data from within manufacturer parts.
  • Transferring a BOM from SolidWorks Electrical directly to the ERP system.

This webcast is suitable for those who have an understanding of SolidWorks Electrical and could be used as a reference by ERP Systems Administrators who wish to set up these links for their users.

SolidWorks Visualize – Dirty Decals

Tips and Tricks - Dirty Decals Decals in SolidWorks Visualize are often used for applying logos, labels and signage onto products.  This blog explores how decals can be used to give realistic defects, dirt and damage onto appearances that would otherwise...

Develop 3D LIVE – Warwick 20th March

This year, DEVELOP3D Live is being held on 20th March at the Warwick Arts Centre, Warwick University, Coventry, CV4 7AL. With over 30 exciting speakers, the event is a great way to get hands-on with the latest technology, advance your workflow and network...

SolidWorks PCB Webinar

SolidWorks Webinar Join us next Tuesday for an open session as we look at the importance of variant management and collaboration. You will see how SolidWorks MCAD and ECAD solutions will help you in designing product variants to achieve maximum efficiency...