Simple String Question
 

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

Simple String Question
 

You are certainly declaring it as a string, but it is the next line that is
wrong, it should be

Import = DDEInitiate("RSLinx", DDETopic)

otherwise you are passing the string value DDETopic, not the value of the
variable DDETopic.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"pete3589" wrote in
message ...

I have a VBA application that needs to look at a certain cell in order
to identify the topic for DDE communications. I think I am somehow not
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 I
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 DDETopic
everything works fine. Am I declaring the string DDETopic correctly?


--
pete3589
------------------------------------------------------------------------
pete3589's Profile:
http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=574163

Simple String Question
 

pls modify ur code:

Import = DDEInitiate("RSLinx", DDETopic)


"pete3589" wrote:


I have a VBA application that needs to look at a certain cell in order
to identify the topic for DDE communications. I think I am somehow not
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 I
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 DDETopic
everything works fine. Am I declaring the string DDETopic correctly?


--
pete3589
------------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=574163

Simple String Question
 

Thanks for the help, that appears to have worked, except now I get
popup that asks what DDE link to use, and it gives me some pre-existin
links that I have created using my DDE client (RSLinx).

This is probably a long shot, but does anyone know how to not have thi
pop up and just use the exact text that is shown in the given cell

--
pete358
-----------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840
View this thread: http://www.excelforum.com/showthread.php?threadid=57416