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

  • Thread starter Thread starter Mainer
  • Start date Start date
M

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
 
Something like:

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

Where alpha is a Named Range
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Importing named range from another workbook 5
Merge Multiple workbook sheets into one workbook 0
How to create absolue path link to another workbook (Excel 2003) 1
Setting Scope of name ranges to particular worksheet 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Question relating to Named Ranges which exist in another workbook. 2
Link behavior with changing data set 3

Back
Top