+ Reply to Thread
Results 1 to 2 of 2

Input data to webform

  1. #1
    mpeplow
    Guest

    Question Input data to webform

    Is it possible for excel to input data into a webform and recive the webpage that is outputed?

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1