ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   External web query from ASP (https://www.excelbanter.com/excel-programming/352477-external-web-query-asp.html)

N0junk

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...

N0junk

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


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com