querytables.add

I have vba macro that makes a web request for stock option quotes as follows: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;https://query2.finance.yahoo.com/v7/finance/options/" & UnderlyingSymbol & "?date=" & ExpiryEpoch & "", _ Destination:=Range("A1")) .BackgroundQuery =...

Members, Description: I like to process data from an internet page. I like to do it in the back ground because i can stop the procedure when the page is not available. Problem: After if have checked "query Refreshing" is true and "query ResultRange.Rows.count <> 0" the query data is not yet...

Hi I'm trying to query a web site and export the data to a single sheet in Excel. I've used the record macro function in Excel (2007) and come up with the following but I want to query over 20 pages from this site and wondered if there was any way in looping this macro to do the hard work for...

Hi, I'm running a QueryTables.Add(Connection:="URL".. that generates a Google site: search. It works fine on my laptop computer, generating the results I expect (the indexed URLs on a site). However, on my desktop, which is a faster machine, I am only generating this Google message...

I have begun to chase my tail on this one, so help me out. I need to summarize some data from multiple files but I can't seem to have the user select the file and import it. It's a ERA(electronic remittance advice) 835 file that will import with the "Import Text File" routine. I've added...

I am writing a generic vbscript that takes delimited files and makes Excel files out of them. Using With objWorksheet1.QueryTables.Add("TEXT;C:\Sample.TXT", objWorksheet1.Range("$A$1")) .Name = "Sample" .FieldNames = True .RowNumbers = False...