Include Computername in data souce path?

Hi all,

I have an Excel file on 'Computer A' which queries an Access database locally. 'Computer B' has a mapped dive pointing to the location of the excel file on 'Computer A'. When the user tries to access the Excel file, they get an error - as the query within the Excel file is looking at "c:\whatever" as the data source. Can I include a computer name in the data source path?

Any help greatly appreciated..

Darren

Ok.. I figured out a workaround. I just mapped drives on both pc's and run the queries to there, but if anybody has any more suggestions.. would still like to her 'em!