When using the results of a "Topics" DDERequest in an Access VB module. The results are returned in a tab delimitered string into my variant string. It there anyway that the values returned by a DDERequest can be converted into an array automatically.
My code is currently as follows:
Dim intChan1 As Long
Dim VariantArray As Variant
intChan1 = DDEInitiate("Excel", "System")
' Establish link. - Dont update the links, not read only
tls = "[open(""" & filename & """,FALSE,FALSE)]"
DDEExecute intChan1, tls
' Get topic list, worksheet name.
info = DDERequest(intChan1, "SysItems") 'returns available commands
VariantArray = DDERequest(intChan1, "Topics") ' Returns the sheet names & "system", separator = tab or chr(9)
My code is currently as follows:
Dim intChan1 As Long
Dim VariantArray As Variant
intChan1 = DDEInitiate("Excel", "System")
' Establish link. - Dont update the links, not read only
tls = "[open(""" & filename & """,FALSE,FALSE)]"
DDEExecute intChan1, tls
' Get topic list, worksheet name.
info = DDERequest(intChan1, "SysItems") 'returns available commands
VariantArray = DDERequest(intChan1, "Topics") ' Returns the sheet names & "system", separator = tab or chr(9)
