I am dealing with an application that gets an update from a 3rd party DDE
server. This occurs when the workbook is opened (uses workbook_open()).

The VB code in workbook_open issues a call to the DDE server. It takes a
few seconds (varies) for the results to come back. Colums B and C are
updated with approximately 1000 rows of data.

The worksheet has a chart. Besides issuing the call to the DDE server, the
VB code in workbook_open() is used to tweak the chart. However, the VB code
must wait until the results come back from the DDE server. That is where I
am having trouble. If I use MsgBox to pause execution, the DDE results come
back, I click OK, and everything works fine. If I instead use
"Application.Wait" to pause for several seconds, it appears that the DDE
updates are blocked, and so the B and C cell values are not populated with
the data that are required by the VB chart code. If I create a "do loop",
testing for the presence of the DDE data, nothing happens, so it looks like
that blocks the DDE updates too.

Does anyone know of a way of pausing a VB script, that will not block DDE
updates to a worksheet? Thanks!