Damn, seems a bit more complicated than normally! I made a VBA code that signs in and takes the HTML table. It would just be much easyer to do it with a query, and faster! and easyer to work with in pivot tables afterwards.
Are you able to get the query to go with the login and password details? It seems like (using httpfox) that it is navigating to this webpage (MyUrl), which is a bit different, but still cant get it to work, cause it goes to login page. Anyway to skip this?
Sub Login_WebQuery()
Dim MyPost As String
Const MyUrl As String = "http://rigpoint2.ods-petrodata.com/currentactivity.php?op=runquery&savedqueryid=19577&skin=rpv2b&prefix="
Const PostUser As String = "[email protected]" 'Change user name here
Const PostPassword As String = "password=Test1234" 'Change password here
MyPost = PostUser & PostPassword
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & MyUrl, Destination:=Cells(1, 1))
.PostText = MyPost
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
