Recent content by fossx

Solution See http://www.tek-tips.com/viewthread.cfm?qid=1369158 The issue is that the DDERequest Objects are different in Access (returns string Variant) and Excel (returns Variant Array). Use Excel.Application.DDERequest in Access to get an array is the bottom line.:)

I am running Office 2003 which has VBA Retail 6.4.8869 running for both Excel and Access. The following code works just fine in Excel but gives a "Compile Error: Can't assign to array" error in Access. It is a DDE request that returns an array. Function doRequest(serverName, topic, request) As...