Code Executes Before Function Updates Data

**OzTrekker** · 06-19-2014, 06:54 PM

I have a workbook that uses a function via an Excel Add-In.
My VBA code is executing before the function finishes collecting data from a network server.
Consequently I end up with #REGISTER in my output instead of numerical values.
How can I make the macro wait until the data update is complete before continuing execution?

**OzTrekker** · 06-19-2014, 07:54 PM

I've just discovered that even if I set Calculation to Manual the Add-In function still pulls data from the server.
It must be using DDE.
That probably explains why the following code doesn't halt execution until data update is completed.
Can somebody confirm my suspicions and/or suggest a solution?

Please Login or Register  to view this content.

**OzTrekker** · 06-19-2014, 09:27 PM

Problem solved.
I simply paused the macro for 5 seconds with the following simple procedure.
This allows the data update to finish prior to macro execution continuing.

Please Login or Register  to view this content.

Code Executes Before Function Updates Data

LinkBack

Thread Tools

Rate This Thread

Display

Code Executes Before Function Updates Data

Re: Code Executes Before Function Updates Data

Re: Code Executes Before Function Updates Data

Thread Information

Users Browsing this Thread

Similar Threads

Code Executes Before Add-In Data Updates

Code executes 8 times without loop statements. Why?

MsgBox does not appear after the code executes.

Code only executes correctly when run from certain worksheet

Vba Code Executes After Copying Sheet

Bookmarks

Bookmarks

Posting Permissions