Referring to cells on other drives

[johncassell]

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

[MattShoreson]

check the tips section on this site...

specifically, http://www.exceltip.com/show_tip/Imp...Excel/429.html

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