Hello,

Can anyone tell me how i can access a workbook from a differen
directory.

For example

Range("A1").Value
Workbooks("Raoul.xls").Worksheets("Sheet1").Range. ("A1").Value

the above code works fine assuming the two workbooks are in the sam
directory.

However:
Range("A1").Value
Workbooks("c:\temp\Raoul.xls").Worksheets("Sheet1" ).Range("A1").Value

The same code in a different directory does not work? How can i acces
a workbook from a different directory.

Help will be greatly appreciated.
Me

--
meefong
-----------------------------------------------------------------------
meefongh's Profile: http://www.excelforum.com/member.php...fo&userid=1538
View this thread: http://www.excelforum.com/showthread.php?threadid=27004