Excel Macro to Pull Components of Backplane

[MalSmith21 0]

Hello,

 

Target:

•  I'm looking to make an excel macro that will take an IP address and pull the components on that specific backplane. Pretty much how RSLinx Classic OEM does it, but it will save me a lot of time if I could automatically put the results into excel.

Example:

• Enter IP "111.111.111.111" into excel, run the macro, and have it fill in the components on the backplane below.
  • 111.111.111.111
  • 00, 1756-L73 LOGIX5573
  • 01, 1756-EN2T
  • 02, 1756-DNB
  • 03, ...
  • 04, ...

Any help that could get me toward this would be amazing. I'm just not sure of the code that would do this.

 

Thank you,

MalSmith21