![]() |
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... |
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