You can probably ask VB to tell you. Put this line after after the first
line...

MsgBox TypeName(DDEChannel)

and put this after the second line...

MsgBox TypeName(DDEItem)

and so on... VB should tell you what Data Type is stored in the Variants and
you can then Dim each of those variables accordingly.

--
Rick (MVP - Excel)



"Gary Keramidas" wrote in message
...
a third party added some code to one of my apps and didn't dim anything.
i'm not sure how to dim these variables. can someone help?

a couple examples in the code:

DDEChannel = Application.DDEInitiate(app:="RSLinx", topic:="T09113")
DDEItem = "Xfer_Sched_New" 'Tag in CompactLogix

DDEChannel = Application.DDEInitiate(app:="RSLinx", topic:="T09113")
DDEItem = "Xfer_Schedule[" & Num_i & "],L1,C1" 'Schedule Tag in
CompactLogix
--


Gary Keramidas
Excel 2003