From the course: AutoCAD Electrical: Implementing PLCs
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Make changes in the spreadsheet - AutoCAD Electrical Tutorial
From the course: AutoCAD Electrical: Implementing PLCs
Make changes in the spreadsheet
- [Instructor] In the previous video, we exported our information out to a spreadsheet. So, we took our PLC Drawing.dwg file in our project project, and what we did was used the To Spreadsheet command and what we did was we exported out only the component information. So, what you're seeing now is the Excel spreadsheet that was created. So, I've opened that up in Microsoft Excel. Now, one of the things that's really important here is this particular spreadsheet does have macros in it. So, you must make sure that those macros are enabled first. You'll notice that in the yellow bar there, I'm actually using Microsoft Excel 365, I've got Office 365, so your spreadsheet may look slightly different and you still though need to enable the macro content. If you're using an older version of Excel, you'll need to go to the Security Settings in the Excel spreadsheet. So, I'm going to enable the content like so, and that yellow bar disappears. Now, as I said in the previous video, we only…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.