| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic web queries with vba
Wonderful people - thanks!
rbarning wrote: Yes I did. You can name the url as a parameter, I called it x. I did the range by multiplying the for next loop number by 200. I'm sure it is not the best code, but it works pretty good. Sub aaa() Dim x As String Dim webq As Integer For webq = 1 To range("F1") x = range("D" & webq) With ActiveSheet.QueryTables.Add(Connection:= _ "URL;" & x, _ Destination:=range("C" & webq * 200)) .Name = "gamelog?playerId=4234" .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = "1,5" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With application.CutCopyMode = False Next webq End Sub Pelham Wrote: Dear Randy Did you ever solve this problem? I am trying to do the same thing with about 200 different web pages and am curious to know what your VBA script looks to do your action. Regards Pelham -- rbarning ------------------------------------------------------------------------ rbarning's Profile: http://www.excelforum.com/member.php...o&userid=37787 View this thread: http://www.excelforum.com/showthread...hreadid=573544 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Creating dynamic sql queries in excel | Excel Programming | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic Web Queries | Excel Programming | |||
| Dynamic Web Queries | Excel Programming | |||
Threaded Mode
