An Excel based guide to CAD automation
A unique approach to CAD automation. This course is aimed at any Draftsight or AutoCAD user wanting to automate drawings or tasks. No programming or even Excel experience is required.
What you’ll learn
- Basic Excel functions – SUM, MAX, MIN, ROUND and more.
- Advanced Excel Functions – Logic, Lookup & reference.
- Adding Macros in Excel.
- Create scripts to automate CAD using Excel.
- Customising Draftsight user interface.
- Customising AutoCAD user interface.
- Command Macros for Draftsight & AutoCAD.
Course Content
- Introduction –> 1 lecture • 1min.
- Excel –> 9 lectures • 55min.
- Script build & test –> 4 lectures • 48min.
- Streamlining the process –> 3 lectures • 24min.
- The End –> 1 lecture • 2min.
Requirements
A unique approach to CAD automation. This course is aimed at any Draftsight or AutoCAD user wanting to automate drawings or tasks. No programming or even Excel experience is required.
This course gives you an easy Excel based approach to CAD automation. Most CAD users are under the impression that coding or programming experience is required to automate drawings. This method uses one basic VBA code which is already written and provided. Adding this code is a simple copy and paste exercise.
Basic CAD knowledge is required but beginner CAD users should easily be able to follow along and even experienced CAD users will likely learn something new. Every Excel function needed to automate CAD is covered. CAD automation is often associated with high-cost CAD packages, but the approach taken in this course is affordable to all small businesses and even individuals. The software used in this course can generally be run on most computers and requires no special hardware requirements. FREE 30 day trial versions are available for both CAD packages. See system requirements for each within the respective website.
Real world examples and practical applications are shown so you can take the knowledge gained and apply it to your day to day working life. All content has been compiled by a CAD user, for the CAD user.