I am writing a number of files for use by staff over our network. Th
problem I have is that the same Drive letter has not been given to al
users and one file opens another by the following code:

ChDrive "L"
ChDir "L:\Community Dividend\New Payments\Regions"
Workbooks.Open "Payment Details\C&E.xls", UpdateLinks:=True

The server is called cash on 'fiesta' and I have tried changing L t
this, to no avail.

Any help greatly appreciated.

Nic

--
Nick
-----------------------------------------------------------------------
Nick S's Profile: http://www.excelforum.com/member.php...fo&userid=1651
View this thread: http://www.excelforum.com/showthread.php?threadid=39500