Excel friends,
I found this code, it gets the nx3 matrix stored in table done with HTML code in passwords.html, and copy all values to the active sheet starting in A1, and works fine so far:
Public Sub GetValues2()
Let TheURL = "http://www.samplewebsite.com/PW/passwords.html"
With ActiveSheet.QueryTables.Add(Connection:="URL;" & TheURL, Destination:=Range("A1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
But, I have two challenges:
1) I need the nx3 matrix assigned to an array, not copied to the active sheet. The three columns to read are UserID, Password, and Date. And,
2) How can I access the same matrix if the folder PW is password protected.
I think it should be "easy" to do for the gurus at the forum, they have the know how.
Any help to develop the VBA is highly appreciated! Thanks!
I found this code, it gets the nx3 matrix stored in table done with HTML code in passwords.html, and copy all values to the active sheet starting in A1, and works fine so far:
Public Sub GetValues2()
Let TheURL = "http://www.samplewebsite.com/PW/passwords.html"
With ActiveSheet.QueryTables.Add(Connection:="URL;" & TheURL, Destination:=Range("A1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
But, I have two challenges:
1) I need the nx3 matrix assigned to an array, not copied to the active sheet. The three columns to read are UserID, Password, and Date. And,
2) How can I access the same matrix if the folder PW is password protected.
I think it should be "easy" to do for the gurus at the forum, they have the know how.
Any help to develop the VBA is highly appreciated! Thanks!
Last edited:
