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

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