RSLINX RSVIEW RSLOGIX5000 Excel

[BMLLER6758]

Hi Folks !

I want to show up 5 Array of 200 Reals in Excel.

Normaly I make a direct connection from RSLinx with copy and paste.

For example:

=RSLINX|JK_Maschine_1!'Schlaufenmessung_02.Gemessene_Laenge_Meter,L1,C1'

But for this its too much work to edit every row in Excel !

Is there someone who has an easy vba script I can use in RSView 32 ???

That would be very nice !!

regards

Bernd

 

[mellis]

The method you have used in the past is called "hotlinking". As you said, it works OK for a few items.

You can do what you want with VBA in Excel.

See the help file for RSLinx, search for VBA. The topic you are looking for is "Microsoft Excel DDE via VBA examples". "Read a block of words", and "Write a block of words" should be what you are looking for.

Good luck,

 

[BMLLER6758]

OK, I found it.

I will give it try.

Hanx !