Pause macro procedure whilst Query runs

Hi All,

I have a macro and half way through it executes a Microsoft Query report and then copies the output of that report to another workbook.

Problem is that before the query has had chance to load (only takes 2 seconds) the copying of the sheet has already been actioned and I am left with a blank sheet.

I have tried pausing the code using this

Please Login or Register  to view this content.

but unfortunately is also pauses the query.

Can anyone advise pls

Thanks
John