unable to search linked excel tables due to file permission

H

Hcoms

Hello,

I have a number of linked excel sheets in an access 2000 database. I have
used VB code to loop through all the linked tables. However an error is now
appearing realting to either file permission error or that the excel sheet
is open. Should it matter that the excel sheet is open , when it is a linked
table?

I use this code to import the spreadsheets:

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel8, FName & "|" &
eFilename, ExcelFile, False, eFilename & "!B:B"

Please can someone help!! Why does it matter if the file is open. on my
standalone system it does not matter at all , however on the office network
it is coming up with this error when used by standard users ( not admin).

Cheers
 
Top