I have a VBA application that needs to look at a certain cell in orde
to identify the topic for DDE communications. I think I am somehow no
declaring my string properly.
Dim Array1 As Integer
Dim Row As Integer
Dim AnInput As Integer
Dim DDETopic As String
DDETopic = Worksheets("Set Points").Range("L4").Value
Import = DDEInitiate("RSLinx", "DDETopic")
Where DDE Topic is the value in cell L4 of sheet "Set Points". When
run the macro it gives me an error that says RSLinx isnt running.
However, if i just put the correct topic name in place of DDETopi
everything works fine. Am I declaring the string DDETopic correctly
--
pete358
-----------------------------------------------------------------------
pete3589's Profile:
http://www.excelforum.com/member.php...fo&userid=2840
View this thread:
http://www.excelforum.com/showthread.php?threadid=57416