Querying another closed Workbook using SQL using ADODB connection

Hi Guys,

I have a variable which stores the Username - strUsrNm. What I want is to search this strUsrNm in the Column A of a closed workbook in another location and get me the entire row.

What I want to achieve by doing is is, when a user open my macro enabled file, his username is stored in strUsrNm at open by using environ($username). And i want to get his details like his phone number, email address, manager name, shift time etc from another excel file.

Here is how far I have reached:

Please Login or Register  to view this content.

What I dont know is how do I get that information using SQL. Please help!!!

Something like

Please Login or Register  to view this content.

Where sheet1 is the sheet name and name is the field name.

It depends on how you want it.
e.g

Please Login or Register  to view this content.