Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84649members
353989posts

[Imported] Scheduled task

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
574

[Imported] Scheduled task

>>Message imported from previous forum - Category:General Items<<
User: andrew, originally posted: 2019-05-29 14:49:31 Id:438
Good morning, I have been tasked with creating a scheduled task (windows task scheduler) to automatically write data to an excel sheet on a file server every hour. Normally I would write a sql query in excel to pull this in but that has to be refreshed manually. does any know a good way to do this?


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
573

Re: [Imported] Scheduled task

>>Responses imported from previous forum


Reply From User: adamwoodland, posted: 2019-05-29 20:09:31
Bit of VBScript using the older COM ClearSCADA automation interface, and then using the relevant COM Excel objects if they still exist, should do the trick.

Alternatively you could use the SQL Export driver the generate the data once an hour and then some Excel magic to import them, for example on Excel load.

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
574

Re: [Imported] Scheduled task

>>Responses imported from previous forum


Reply From User: adamwoodland, posted: 2019-05-29 20:09:31
Bit of VBScript using the older COM ClearSCADA automation interface, and then using the relevant COM Excel objects if they still exist, should do the trick.

Alternatively you could use the SQL Export driver the generate the data once an hour and then some Excel magic to import them, for example on Excel load.