Is it possible for excel to input data into a webform and recive the webpage that is outputed?
Is it possible for excel to input data into a webform and recive the webpage that is outputed?
i have done this in the past.
You will need to know the PostText field names that you send your date to so that the webform can return your required data.
Some times I have not been able to get the desired results as I have had trouble identifying the PostText Fieldnames
Dim wsT As Worksheet
Set wsT = ThisWorkbook.Sheets("Trash")
With wsT.QueryTables.Add(Connection:= _
"URL;http://YourWebSite", _
Destination:=wsT.[a1])
.PostText = "number=" & sTelNum & "&site=wini"
.FieldNames = True
.RefreshStyle = xlOverwriteCells
.RowNumbers = False
.FillAdjacentFormulas = False
.RefreshOnFileOpen = False
.HasAutoFormat = False
.BackgroundQuery = False
.TablesOnlyFromHTML = False
.Refresh BackgroundQuery:=False
End With
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks