Using A Web Query Instead: Macro that will automatically log me into web application Excel help response (25 Nov 2010)

Excel Help for Using A Web Query Instead in Analyzing Corporate Financial Data

Forum Topic

Using A Web Query Instead

Rate this:

(3/5 from 2 votes)

Instead of initiating and using the IE object, why not try using a simple web query instead. The following code may work.

VBA Code:

Sub Login_WebQuery()
Dim MyPost As String
Const MyUrl As String = "https://www.btwholesale.com/siteminderagent/forms/login.fcc"
Const PostUser As String = "USER=" & Worksheets("Login Data").Range("C5").Value
Const PostPassword As String = "&PASSWORD=" & Worksheets("Login Data").Range("D5").Value

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

Excel Business Forums Administrator

Posted by Excel Helper on 25 Nov 2010

View Full Post

Find relevant Excel templates and add-ins for Using a web query instead in the Excel Business Solutions Directory

Using a web query instead

Excel Help for Using A Web Query Instead in Analyzing Corporate Financial Data

Using A Web Query Instead