1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| Function Fondamentaux(dlname As String)
Dim wb As Workbook
Workbooks.Add.Activate
ActiveWorkbook.worksheets.Add
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;dlname", Destination:=Range( _
"$A$1"))
.name = "q?s=asmtx&d=t"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
End With
ActiveSheet.Cells(1, 1).Offset(88, 1).Resize(7, 1).Cut Destination:=Workbooks("classeur1").worksheets("fondamentaux").Cells(2, 2)
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
End Function |
Partager