Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy query table data
when i run the following macro i get the data from the website, but when i
try to copy it to another location i get the following: "ExternalData_55: Getting Data ¦" how can i get the macro to wait for the data to be imported before copying? any help is greatly appreciated - here is macro: Sub MacroTest1() With ActiveSheet.QueryTables.Add(Connection:="URL;http://www.license.state.tx.us/ABProjectRegistrationOnline/ABProjectPrintConfirmationGeneral.aspx?strWhereURL =ABDataSearch&strProjNum=EABPRJA8800466", Destination:=Range("a1")) .WebFormatting = xlNone .WebSelectionType = xlSpecifiedTables .WebTables = "5" .Refresh End With Range("a1").Copy Range("b1").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy query table data
simply, you can use a " Wait " function
newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 10 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime "namenorg" δΎε½οΌ when i run the following macro i get the data from the website, but when i try to copy it to another location i get the following: "ExternalData_55: Getting Data ¦" how can i get the macro to wait for the data to be imported before copying? any help is greatly appreciated - here is macro: Sub MacroTest1() With ActiveSheet.QueryTables.Add(Connection:="URL;http://www.license.state.tx.us/ABProjectRegistrationOnline/ABProjectPrintConfirmationGeneral.aspx?strWhereURL =ABDataSearch&strProjNum=EABPRJA8800466", Destination:=Range("a1")) .WebFormatting = xlNone .WebSelectionType = xlSpecifiedTables .WebTables = "5" .Refresh End With Range("a1").Copy Range("b1").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QUERY EXCEL TABLE DATA | Excel Programming | |||
SQL query JOINED Data from which Table? | Excel Programming | |||
Copy old Data from web query while keeping previous days data | Excel Worksheet Functions | |||
Userform web Data query table | Excel Programming | |||
Append Data to Table after Web Query | Excel Programming |