DDEExecute With Very Long Strings

[ags5406]

I'm using DDEExecute to send some MapBasic commands to MapInfo
Professional (I don't have the standalone MapBasic program so I'm
cheating a bit) from Excel VBA. For the most part it works flawlessly.
I'm pretty happy.

However, I have some very long MapBasic commands that don't seem to be
sent completely.

For examle, the MapBasic command "Create Cartographic Legend" only
works if I have a small number of items for the legend. If the string
is very long the entire command does not get sent or does not execute.

Has anyone else ever had this problem with sending very long strings to
MapInfo Pro from Excel VBA using DDEExecute? Or to any other programs
for that matter?

Is there a string length limit?

Thanks in advance.

 

[John.Greenan]

From memory there is a limit of 255 characters in the string in a DDEExecute
call from Excel VBA.

This is sort of backed up by this
http://www.kbalertz.com/142357/Visual.Basic.Example.Using.BuildSQL.aspx

I know that's a bit woolly, but it was a long time ago. Good luck

 

[Peter T]

FWIW, in a quick test from Word sending a long string to an Excel cell with
DDEExecute I found the length was truncated to 256 in the cell.

Regards,
Peter T