Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC Link changing selection criteria
Hi
I have an ODBC link to some accounts data. I want to list the transactions for a date range. I have DateFrom and DateTo named ranges. I have a macro to refresh the data but this gets all of the data and I want to restrict the data returned to the date range, which changes on a regular basis. The refresh data line in the macro is below. Can I change this to pick up the date from and date to criteria from the named ranges at the time of refreshing the data? Selection.QueryTable.Refresh BackgroundQuery:=False Thanks Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC Link changing selection criteria
Hi
I have done some investigations and found that you can link query parameters to a particular cell on the spreadsheet, which partially helps but the query parameter that I want to link is a date and this does not seem to be able to be linked to a cell Can anyone help? Chris. "Chris F" wrote in message ... Hi I have an ODBC link to some accounts data. I want to list the transactions for a date range. I have DateFrom and DateTo named ranges. I have a macro to refresh the data but this gets all of the data and I want to restrict the data returned to the date range, which changes on a regular basis. The refresh data line in the macro is below. Can I change this to pick up the date from and date to criteria from the named ranges at the time of refreshing the data? Selection.QueryTable.Refresh BackgroundQuery:=False Thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing ODBC server (MySQL) | Excel Worksheet Functions | |||
Changing ODBC link in a query | Excel Discussion (Misc queries) | |||
Changing ODBC | Excel Discussion (Misc queries) | |||
paste special keep odbc link | Excel Discussion (Misc queries) | |||
ODBC Link to db with custom modules | Excel Discussion (Misc queries) |