Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Web Query Errors | Excel Worksheet Functions | |||
Editing external DB query | Excel Discussion (Misc queries) | |||
External Query questions | Excel Programming | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Get External Data Query | Excel Programming |