Enrique A. Santos KM4ZQC
asked on
Web Query
In the code below, I want to include Login & Password Parameter.
Sub WebQuery()
ActiveWorkbook.Worksheets. Add
With ActiveSheet.QueryTables.Ad d(Connecti on:= _
"URL;https://qhos.qualcommapps.com/QHOS/~hours/driverweek.aspx?id=93465", _
Destination:=Range("$A$1") )
.Name = "q?s=usdCAd=x_1"
.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
.WebPreFormattedTextToColu mns = True
.WebConsecutiveDelimitersA sOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Please advise. Thank you.
Sub WebQuery()
ActiveWorkbook.Worksheets.
With ActiveSheet.QueryTables.Ad
"URL;https://qhos.qualcommapps.com/QHOS/~hours/driverweek.aspx?id=93465", _
Destination:=Range("$A$1")
.Name = "q?s=usdCAd=x_1"
.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
.WebPreFormattedTextToColu
.WebConsecutiveDelimitersA
.WebSingleBlockTextImport = False
.WebDisableDateRecognition
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Please advise. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.