Hi,

I have an excel file ("calculations.xls") in my sharedrive folder
"S:me\myfolder\mysubfolder". I intend someone to run a macro on this
file, and then the results from this are used for another macro in
another file ("database"). Now, for the second macro, I want to
reference a sheet named "results" in "calculations.xls" . How do I do
it ?

In John Walkovich's book, I see things like 'C:\My documents\[budget
2004]Sheet1'

and for networks, things like:

'\\DataServer\files\[budget 2005]Sheet1'!

But I'm using:

1. named worksheets in an external reference
2. this external reference may or may not be open at the time it is
referred to, and
3. It is on the network (sharedrive)

Do you think you can help?

Thanks in advance,

Joe.