111 reputation
12
bio website
location
age
visits member for 3 years, 6 months
seen Jun 29 '11 at 17:29

Mar
11
awarded  Notable Question
Aug
3
awarded  Popular Question
Jun
9
comment Pass a cell contents as a parameter to an excel query in Excel 2007
Hello Lance, Thanks for the link. Unfortunately, I saw it before and tried but wasn't very successful. The problem was this line "Set oQuery = Sheet3.QueryTables(1)" and I couldn't move forward because I didn't really know much about QueryTables and couldn't tell if the one I created through the external source was really inside Sheet3.
Jun
9
awarded  Student
Jun
8
comment Pass a cell contents as a parameter to an excel query in Excel 2007
Actually, it would be perfect if the excel file (with the data) and the sql query could be controlled from the function too. Like that all I need to do happens in one place. Thanks!
Jun
8
asked Pass a cell contents as a parameter to an excel query in Excel 2007