Hello,



I need to retrieve values in another EXCEL file from an EXCEL file, but this one is closed.

I have used the function proposed by Silkyroad (https://excel.developpez.com/faq/ind...tClasseurFerme)

The function returns the result: [B] #VALUE! [/ B]

I found the following additional info, maybe? at the origin of my pb. Indeed Silkyroad mentions:

You must first enable the Microsoft ActiveX Data Objects x.x Library reference to use the examples in this tutorial.

In the macro editor:
Tools menu.
References.
Check the "Microsoft ActiveX Data Objects x.x Library" line.
Click the OK button to validate.

x.x depends on the version installed on your computer.

Some suggested examples allow you to manipulate the tables and need to enable the Microsoft ADO ext x.x for DLL and Security reference.


Knowing that I use MS Office 2013 (15.0.5075.1000) and that there are many references which ones should I activate? Perhaps another porblem ?

Thanks in advance.

Best regards.
Jérôme

You could, of course, just use an external-reference formula.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Can you exploit ? I am beginner

An external reference formula contains the path, filename, sheet name and cell reference of the cell whose value you want to retrieve. Such a formula typically looks like:
='C:\Users\UserName\Documents\[SourceWorkbook.xlsx]Sheet1'!$A$1

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Ok. Thanks