I have followed the examples here, but I still can't get excel to do what I
want, and I believe I'm having a syntax issue.

In my workbook, I'm trying to refer to a workbook located on a netwrok drive:
The network path and file name is:
P:\My Documents\Alpha_Numeric.xls

in cell A11 is the text: P:\My Documents\[Alpha_Numeric.xls]Sheet1

What I want to do is first a simple indirect using this string on a single
cell.

i.e. =INDIRECT("'"&A11&"'!$A:$2")

This is not working. I am getting a #REF error. I am getting some same
error trying to use indirect on a file on my desktop.

cell a3 = C:\Documents and Settings\#jlowens\Desktop\[Alpha_Numeric.xls]Sheet1
=INDIRECT("'"&A3&"'!$a:$2")

Can someone please explain what I am doing wrong.

Thank you