Linked Table (Excel file) that changes by User?

[Philem]

Hullo!
Situation:
Several users maintain their own datasheets in Excel, and each sheet has PRECISELY the same format, all stored in the same network directory, all with unique names and record information that varies from user to user. Each user needs to have the same set of queries run, using their own Excel sheet as a source.

Question:
How to vary the linked table source via VBA?

Have:
Code to find UserName; assume return is STR type.

Example:
The linked table is called UsrInfo. When Bob logs into the database and runs the Results query, it would need to programmatically change the source for UsrInfo to match Bob's sheet.

Hopefully this makes sense. Any help would be appreciated.

Thanks!

P

 

[Philem]

RESOLVED

Had to go different path, using multiple queries, each referencing different users.

Thanks for looking, though!

P