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

Instead of changing drives, why not just use the full UNC path to the
file?:

Example:
DIM strPath as string

strPath = "\\Fiesta\Cash\Community Dividend\New
Payments\Regions\Payment
Details\"

Workbooks.Open strPath & "C&E.xls", UpdateLinks:=True


Something you can work with?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=395002

Worked like a drea

--
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