If you have a file called Junk Junk.XLS and in another file you type = and
then click on a cell in the first file you get a formula such as ='[Junk
junk.xls]Sheet1'!$C$1
So with in Book1 when I use :
A1: [junk junk]
B1: Sheet1
C1: A2
D1: =INDIRECT("'"&A1&B1&"'!"&C1)
I am able to get the value from A2 in the Junk Junk file
To make it clearer I will replace single quotes (apostrophes) by asterisks
=INDIRECT("*"&A1&B1&"*!"&C1)


best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"tim_o_mast" wrote in message
...
I need to use an Indirect to another wookboot that has a multi-word name ie
'expense report' not something like 'er' in my excel I did the following
to
test
a1 = [expense report]
b1 = sheet1
c1 = a2
d1 = indirect(a1&b1&"!"&c1)

if I use a name in a1 with no spaces ie 'er' then the indirect works but
if
I use the above example I always get #ref error in cell. Anyone got any
ideas?

I also did try d1 = indirect("'"&a1&b1&"'!"&c1). It didn't work either.