+ Reply to Thread
Results 1 to 2 of 2

External web query from ASP

Hybrid View

  1. #1
    N0junk
    Guest

    External web query from ASP

    I am trying to import data using VBA from an asp page that contains check
    boxes like the following
    http://www.asp101.com/samples/checkbox.asp
    but excel drops the boxes all together and shows no possible way of telling
    whether the boxes were checked during the import. Any thoughts would be
    greatly needed...

  2. #2
    N0junk
    Guest

    RE: External web query from ASP

    this is the code i am using

    Sub yup2()
    With UserForm1.QueryTables.Add(Connection:= _
    "URL;http://ghsreports/deployment_calendar.asp?dcid=1" _
    , Destination:=UserForm1)
    .FieldNames = True
    .RefreshStyle = xlOverwriteCells
    .FillAdjacentFormulas = False
    .RefreshOnFileOpen = False
    .HasAutoFormat = True
    .BackgroundQuery = False
    .TablesOnlyFromHTML = False
    .Refresh BackgroundQuery:=True
    '.SavePassword = False
    'SaveData = False
    End With
    End Sub

+ 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