Browse
Category
DiscussionsUncategorized

Anyone well-versed in Visual Basic?

Closed
CombatWars

I'm in a conundrum at this moment. Can anyone write a code for me that sends data from a cell in Excel through DDE to RSLinx?

It's simple enough getting data from RSLinx to Excel but I can't find anything to send the data back to RSLinx that works.

ex. Send B27 > N7:0, C27 > N7:1, D27 > N7:2, etc.

I've tried what I found on this site but it doesn't work for some reason that I don't understand. I've probably fucked it up somehow or another.

Before anyone asks, I was asked by my father to help him with this problem.

11 years ago*

Comment has been collapsed.

2 Comments
Doppleganger

What did you try exactly. That link talks about cell formulas and macros, so it depends what you tried. I've never tried Excel to RSLinx and haven't worked with VB for a little while, but from the example(s) it looks okay.... Maybe if you had a screenshot or pasted what you had and where you have it (i.e. in a cell or macro).

11 years ago
Permalink

Comment has been collapsed.
CombatWars

I substituted part of the code with another and it worked. My only problem now is that it only sends integers through DDE and nothing else. It doesn't send blank cells, symbols, or text. :/

11 years ago
Permalink

Comment has been collapsed.

Closed 11 years ago by CombatWars.