calling a value from another file using a variable in the file nam

D

DA_Potts

I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?
 
D

DA_Potts

DA_Potts said:
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?

Sorry... I forgot to mention I am using Excel 2003.
Click to expand...
 
D

DA_Potts

I have no idea what you mean by this response....
T. Valko said:
See your other post

--
Biff
Microsoft Excel MVP


DA_Potts said:
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3" represents
a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls, (where
E3=3), sheet 1, and cell E22.

Any ideas?
Click to expand...
Click to expand...
 
D

David Biddulph

What he means is that you asked broadly the same question in another group,
and his answer is there. Ths sort of confusion (and particularly when you
omit some of the detail in one version of the message) is why multi-posting
is a breach of netiquette. Next time, choose one group and stick to it.
--
David Biddulph

DA_Potts said:
I have no idea what you mean by this response....
T. Valko said:
See your other post

--
Biff
Microsoft Excel MVP


DA_Potts said:
I want to call a value from another excel file using a different file
depending on the date. In my attempt, which I have below, "E3"
represents
a
date of the month, 1-31.

=INDIRECT(CONCATENATE("'[daily flash ",E3,".xls]sheet1'! E22"))

In this case I want the data from a file called Daily Flash 3.xls,
(where
E3=3), sheet 1, and cell E22.

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 

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

calling a value from another file using a variable in the file nam 3
How to search for a value in a column in another Excel file 6
How do I delete an xls file using a .xl macro in a different file? 3
Creating a linked file based on variable location reference 2
Use external file variable in formula 2
Export query to Excel use data from the query as part of file nam 5
Importing and merging Excel files by using a macro 4
Using text in cells to build a link to within another file 2

Top