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