Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub Extracttable()
' ActiveWorkbook.Worksheets.Add With ActiveSheet.QueryTables.Add(Connection:= _ "URL;file:///D:/group2005/group2005.htm",Destination:=Range("A1")) .Name = "srlgroup2005" .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" .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With End Sub How can i amend the above code to increment .WebTables by 1 - to say 20 to extract all 20 tables in the file Thxs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to increment within For Next Loop | Excel Discussion (Misc queries) | |||
Increment/Increment letter in alphabetical order | Excel Programming | |||
Dynamic variables in .WebTables | Excel Programming | |||
Increment column in loop | Excel Programming | |||
Increment through For Next loop | Excel Programming |