Referring to cells on other drives
 

Hello, could someone point out where I am going wrong with the following
code..

We have a server called 'Gateway' and there is a folder on there called
'Workshops'.

Now in this folder there is a spreadsheet called 'NewJobBook.xls' and I
would like to return the value of cell A1 in the worksheet
'WShopCurrent' in a message box.

How would I go about writing the code for this please?

Thanks

John C


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=534476

Referring to cells on other drives
 

check the tips section on this site...

specifically, http://tinyurl.com/qrcan

Tweaking will need to be done but it's a great start.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=534476