Can you explain in words what you are trying to do. Opening a databae
like you are doing you probably want to use SQL (string Query Language).
the SQL provides filtering of the database to return only certain
record from the database. You don't have any SQL statements so it
appears you are returning all the records.

You are using on the worksheet a named range "User_Id". does this
range contain one or more than one ID. I'm not usre from your code if
you are retuning one or more than one user ID from the database.

What may help is if you record a macro while manually performing a
query of the database which will get the correct syntac of the required
SQL. From the worksheet in excel perform the following after starting
to record a macro

Data - Import external data - new Databasequery

Setup the database filters using the wizard and post the recorded
macro.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148050