[attachmentid=3567][attachmentid=3568]I know you gurus are probably sick of this topic because it gets alot of traction on the board, but I need to find out if in the sample attached can I expand this formula to execute mass cell transfer to an RS View application. In other words can I send data from all the cells with data with one vb code instruction or do I need to write this macro (changing variables of course) for every cell I want to send? I really want to learn VB but unfortunately don't have any peers at my job that have any clue so I'm on my own. Thanks in advance for your advice.

If you are going to write multiple cells of data to multiple tags you'll need to loop the macro cahnging variables. One example of doing this from Excel to a PLC not RSView is found in the downlioads section.

A little off topic but why DDE. IF you're moving any amount of data with any frequency and just learning, invest your time in OPC. It has more overhead to learn, but tons more horsepower once running.

Like I said I am new to these open communication protocols and did use OPC to set up the data exchange from my laptop(server) to the processors, and it works great. From the reading I've done so far I was under the impression that I had to use DDE to get data from a microsot app like Excel.

So if I understand you correctly you are saying with my current OPC server and client nodes set up in RSview I can pull data from Excel spreadsheets that reside on the same computer. I propably need to add another node in the project that points to the spread sheet .xls that has the data. I feel like I can handle that portion as i have set up 15 nodes in the project that are functioning, but my dilema is going to be getting the spreadsheet data into the processor with VB commands.

Check out the downloads section and you'll see an Excel and VB samples using OPC. Study them and post your problems in the forum and you'll have help from the experts here.