The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as Facility Hero) app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
Follow http://www.powerlogic.com/kbarticle.cfm?myrequest=RESL182688%20AND%20viewing to be able to import data into an excel spreadsheet. In order to have this data update every time you click on a button, follow the resolution below.
Causes and Fixes
This procedure will create a button that you can push in order to automate the update process with a macro.
Put your cursor inside the contents of the database query in your spreadsheet; that should cause the External Data toolbar to pop up.
Select a cell in the database query range, such as B5, and click on the Refresh button (orange exclamation point) on the External Data toolbar (let it run through its process) and on the Stop button on the Stop Recording toolbar. If the toolbar doesnt pop up, do one of the following: Select either Tools, Macro, Stop Recording or View, Toolbars and Stop Recording. Then click on Stop.
Now that weve recorded a macro, we need to attach it to a button in the spreadsheet. Though any type of button will work, well add one from Excels Forms toolbar. Click on View, Toolbars, Forms. Left-click on the button (its circled) and then release it.
Although it took many setup steps, now you can save loads of time by updating your spreadsheet with new database information with just one click.
Last Revised: May 2008
Applies To: ION Enterprise 5.6, 5.5 and 5.0
Original Author: MN
All content © 1992-2008 Schneider Electric
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!