Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delay copy & paste of data until web query refreshes?
Paste the below procedure and call Wait (2) in your code to wait for 2
seconds... Sub Wait(sngDelayInSecs As Single) EndDelay = Timer + sngDelayInSecs Do While Timer < EndDelay DoEvents Loop End Sub -- If this post helps click Yes --------------- Jacob Skaria "CM4@FL" wrote: I need to delay copying my data in cells E10:N:10 while my web query completely refreshes, after the refresh is complete then can I copy the data. Can anyone help me with the delay function? Range("B4:C4").Select Selection.Copy Range("E4").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveWorkbook.RefreshAll ********* NEED A DELAY FUNCTION HERE ********* Range("E10:N10").Select Selection.Copy Range("E47").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delay copy & paste of data until web query refreshes? | Excel Programming | |||
copy chart delay (musa.biralo query) | Excel Programming | |||
Copy/Paste in Excel Delay | Links and Linking in Excel | |||
"New Web Query" always refreshes data from website (3 times) | Excel Worksheet Functions | |||
Simple question: How to get web query to NOT overwrite data when it refreshes? | Excel Programming |