Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parameter Driven Query
Hi,
I'm used to using MS Query to return data to Excel, but there's a whole stack of queries that I run each month (literally, dozens) where the date range needs to be changed. I'm wondering whether I could put the chosen date ranges into an excel spreadsheet, maybe in the format: Col 1 Col 2 Col 3 Col 4 sheet query start date end date ....and use VBA to modify the SQL for me. Alternatively, can the SQL itself be written to request a parameter from a particular location? Any ideas? This could be a massive time saver! Cheers, Tom. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Web Query for Java Applet driven data website | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
parameter and macro driven pivot table filter? | Excel Programming | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |