A question about VBA Code Processing?

[JeffGrant]

Hi All,

My excel/vba/PQ model is quite large and heavily coded.

Often I find that parts of the VBA are missed. What I have found is the code is missed because the system is doing other processors.

In an attempt to fix this, I have started putting Application.Wait Now + Timevalue(whatever) at critical points. Tis has definitely helped the issue.

Since I have not been exposed to such a large model, I am wondering if putting in "Wait" statements like this is common place for large models, or am I putting a band aid on a bigger problem?

Looking forward to hearing your opinions.

 

[GTO]

You will no doubt receive better/more qualified opinions than mine; the number of occasions I've had code running over itself is limited. That said, and without some example code to recreate, my only input would be to look at DoEvents and/or Application.Ontime. Basically .Wait is a guess at how long we need to wait, and if you can test until something is done would likely be quicker.

Mark

 

[jkpieterse]

I bet your issue is with asynchronous refreshes. I seem to recall you can set a property of a query according to your needs. For example, the Refresh method of "regular" (old style) queries has an async argument.