VBA Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Preacher Man - 30 Aug 2006 23:21 GMT

I have a seeming simple task that I can't figure out.

I have a macro set up to refresh a query and then do some copying and
pasting of cells.
What code can I use to tell the macro to wait until the query is finished
refreshing until it does the copy and paste?

Here is the simple code.

Sub GetData()
ThisWorkbook.RefreshAll

' I need the following code to be run after the refresh is finished'
Range("J5").Select
Selection.Copy
Range("J6:J65000").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWindow.LargeScroll ToRight:=-1
Range("D1").Select

End Sub

Reply to this Message

Jean-Guy Marcil - 31 Aug 2006 01:47 GMT

Preacher Man was telling us:
Preacher Man nous racontait que :

> I have a seeming simple task that I can't figure out.
>
[quoted text clipped - 18 lines]
>
> End Sub

This is a word.vba group, not an Excel one.
Try:
excel.programming

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message

Gary''s Student - 01 Sep 2006 18:29 GMT

Objects that have the BackgroundQuery property set to True are refreshed in
the background. You need to set them to false. That way the VBA will wait
until the refresh completes.

Gary's Student

> I have a seeming simple task that I can't figure out.
>
[quoted text clipped - 18 lines]
>
> End Sub

Reply to this Message