Network Drives

  • Thread starter Thread starter Nick S
  • Start date Start date
N

Nick S

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