Forum Discussion

JMW89's avatar
JMW89
Copper Contributor
Oct 26, 2021

File name in a formula.

Is there a way to refer to an Excel file in a formula by using the content of a specific cell ?

In the cell G48, I'm entering manually the file name but I would like to take the content of the cell A48 to compose the file name.

 

Any advice ? Thalns,

Formulas and Functions

2 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 26, 2021

    JMW89 

    You can use the INDIRECT function for this, but it will only work if the other workbook is open in Excel. INDIRECT does not work with closed workbooks.

    The formula would look like this:

    =INDIRECT("'["&A48&".xlsx]Fiche'!B7")

    Note that the path is not mentioned in the formula since the other workbook must be open.

Resources