that's not true either. Looks like you are building your own obstacles to
reaching a solution:
http://nickhodge.co.uk/gui/datamenu/...taexamples.htm
http://www.dicks-clicks.com/excel/Ex...htm#Parameters
--
Regards,
Tom Ogilvy
"Nagesh" wrote in message
...
Tom,
Adding a criteria there would require value to be provided in a popup
window. I am looking for value to be picked up from a cell which is my
active
cell.
Thanks,
"Tom Ogilvy" wrote:
Get External Data supports adding a criteria. In MS query, look in the
menu
when you set up the query.
--
Regards,
Tom Ogilvy
"Nagesh" wrote in message
...
Hi,
I have written code to import data from Access to Excel using VB code
since
I wanted values to be filtered on a value. I picked up this code from
MS
site
which used ADODB for connection. I found that this code was not
working
properly despite choosing proper references.
Is there a simple way I can get data from Access to excel 2003 filtred
on
a
value which is stored in adjacent cell. (If I use get external data in
Excel,
it dumps the entire table).
Appeciate your response.
Thanks,