getting data from a range in another workbook (excel 2003)

[Mainer]

i'm not sure of the command to get a named range for a workbook in the same
folder as the workbook i'm using

 

[Gary''s Student]

Something like:

=SUM('C:\Documents and Settings\Owner\My Documents\Book2.xls'!alpha)

Where alpha is a Named Range

 

[Mainer]

can i just put the workbook name if the workbook is in the same folder?

 

[Gary''s Student]

Try it and see.


Post back your results