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
Having learned to import data into an Excel spreadsheet using the procedure in http://www.powerlogic.com/kbarticle.cfm?myrequest=RESL182688%20AND%20viewing. If you would then like the query to update on a scheduled interval (e.g. every 15min) follow the procedure below.
Causes and Fixes
Automatic Scheduled Update Of Your Excel Sheet Query.
(This procedure starts assuming the query already exists in excel)
5) Now that weve recorded a macro we need to edit it to automatically update itself on a scheduled basis. Type Alt + F11 in the excel window to bring up the macro code.
Now your macro should update the spreadsheet at your scheduled interval.
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!