Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need simple formula to find one string in another | Excel Discussion (Misc queries) | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple String Conversion - HELP | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |