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

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

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

Something like:

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

Where alpha is a Named Range
--
Gary''s Student - gsnu200908


"Mainer" wrote:

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

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

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

"Gary''s Student" wrote:

Something like:

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

Where alpha is a Named Range
--
Gary''s Student - gsnu200908


"Mainer" wrote:

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

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

Try it and see.


Post back your results
--
Gary''s Student - gsnu200908


"Mainer" wrote:

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

"Gary''s Student" wrote:

Something like:

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

Where alpha is a Named Range
--
Gary''s Student - gsnu200908


"Mainer" wrote:

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