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
|