Problem with Macro
Dim TotTemp As Double
Private Sub PSTimer1_Tick()
Chan = Application.DDEInitiate("WinWedge", "COM2")
mydata = Application.DDERequest(Chan, "FIELD(3)")
TotTemp = TotTemp + mydata
ctr = ctr + 1
End Sub
I am getting "Type Mismatch" error at TotTemp = TotTemp + mydata .
Any ideas ?
|