Network Drives

[Nick S]

I am writing a number of files for use by staff over our network. The problem I have is that the same Drive letter has not been given to all 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 to this, to no avail.

Any help greatly appreciated.

Nick

[Ron Coderre]

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

[Nick S]

Worked like a dream