Anyone know a better way to suspend execution of VB code until an activex control responds and the event is handled other than using a loop with a doevents statement in it. Such a loop seems to be slowing my application significantly. Thanks.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.