Hi! Although it should be relatively simple, I'm getting a 'Failed to Login' error when running the following code in an Excel macro:
<font class="small">Code:</font><hr /><pre>
Set tdc = New TDConnection
tdc.Login "user1", " "
tdc.Connect "PROJECTS", "IMP_PROJS"
I referenced OTA COM Type Library (OTAClient.dll). Would there be anything I'm missing for running this code in Excel? Any suggestions are appreciated.