Indirect function closed workbook

Hello,

no, Indirect does not work on a closed workbook.
Here is a custom function:
https://excel.developpez.com/faq/?page=Recherche#IndirectClasseurFerme
eric

--
By continually trying, one eventually succeeds.
So the more it fails, the more chances it has to work. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), remember to mark it as resolved. Thank you

Hello everyone

Your file in return
http://www.cjoint.com/c/GIduJnaQueB

> eric.
1. people are mean, I reset the counter to zero ;-)
2. I had to modify the Target calculation like this
Target = Cell.Value & ":" & Cell.Value
3. if you could comment the macro code ....

best regards

It depends on the formula... More precisely on the search function that includes the INDIRECT function:
IF - COUNTIF - SUMIF - VLOOKUP - SUMPRODUCT - OFFSET - MATCH

--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)

Chrystèle, I believe I'm going to let you figure it out with your file:
The one you attached doesn't match the explanations in your initial message at all: it's almost empty, with just 4 data points and no formulas or functions...

You stated, "You will find attached the two files" but there is only one file containing 2 filled sheets and one blank sheet.

--
Retirement is nice! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)

I recreated the links.
Here are the links, (one link per file):
http://www.cjoint.com/c/GIdnL1tArU5
http://www.cjoint.com/c/GIdnNfnJlw5

In the file "September", I want to retrieve the information from the file "01 September" (the 100,000 from cell A2) into cell B2 of the file "September". I use the INDIRECT formula for this:
=(INDIRECT("'["&B1&".xlsx]"&"Equipment 1"&"'!$a2"))
B1 = Name of the search file -> 01-September
Equipment 1 = the tab where I want to look for the information
A2 = the cell where the information is located
I get 100,000 if the file 01-September is open.

Thank you,
Chrystèle

Chrystèle, working on Excel is not difficult, but it requires the utmost rigor! Your formula in B2 refers to the file whose name is in B1, so ""01 Septembre"; however, the file you sent us is named ""01-septembre"!
Once you correct this error, close the file 01-septembre; Excel will automatically indicate, in the formula in B2, the complete path by adding the name of the directory in which the closed file is located.
But if you start moving one of the folders, or sending it via USB or email, everything falls apart!
--
Retirement is nice! Especially in the Antilles... :-)
Raymond (INSA, AFPA, CF/R)

Thank you Eric,
I am sending you back the file "September". I copied the function and the formula LireCellule_ClasseurFermé, but I feel like the function is not being taken into account, I really don't see how to do it...

http://www.cjoint.com/c/GIdqQ7wAzS5

Chrystèle