XLL plugin's DDEConnect() fails when connecting to Excel?

Question

I have a problem with connecting to Excel, there's a plugin that reads from db and tries to fill excel sheet with data across DDE, and it seems to be failing sometimes on DDEConnect function with error number 16390 - DMLERR_INVALIDPARAMETER Invalid parameter to DDEML function call.

What is more interesting it is failing more often when pressing F9 (recalculates all formula in worksheet) then running from macro which goes through all worksheets and recalculates the formulae.

Anybody with experience of DDE with Excel?

Regards, Mika

Answer 1

The problem might be that DdeInitialize() was not yet called for the current thread