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