Cancel
Showing results for 
Search instead for 
Did you mean: 

Excel VBA Agent using MindConnect API (Southbound)

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

I was able to write a southbound agent in Excel VBA (see attached)

Thanks to Senh Mo Chuang (CMO), and the training at the MindSphere Academy in Austin TX, I was able to do this in a couple of days. 

 

How practical is this? It's great for a demo.

No programming software needed, no add-ins, no ten different files to jump around to find - just Excel 2013 or higher!

 

If you want to learn the functionality of the southbound API, you can start here. 

I tried to make the code simple to follow, and avoided a class strucuture. I hope it works for you, and provides some insight into developing your own agent.

 

2018-11-06 23_52_44.png

 

 

2018-11-07 00_05_26.png

 

 

Instructions on how to use this to send time series data to MindSphere can be found in the first worksheet.

This assumes you know how to use Asset Manager and Fleet Manager.

 

2018-11-06 23_53_35.png

4 REPLIES 4

Re: Excel VBA Agent using MindConnect API (Southbound)

Experimenter
Experimenter

Senh Mo is a cool guy.

Re: Excel VBA Agent using MindConnect API (Southbound)

Genius
Genius

Legend.

Re: Excel VBA Agent using MindConnect API (Southbound)

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

I've updated the Excel VBA Agent (attached) so that it can send data continuously. It auto generates data in Excel and sends to MindSphere.

 

I've done demos with this twice, and has been well received with reactions of how easy it was to send data to MindSphere!

Re: Excel VBA Agent using MindConnect API (Southbound)

Siemens Creator Siemens Creator
Siemens Creator

Is there a limit in amount of transferred datapoints?