Thank you for your answer but let's suppose that I have to import data from multiple closed excel files and I don't want to write each time:
A1: R:\Dati\[ClosedExcel1.xls]SheetName!Location Cell
B1: R:\Dati\[ClosedExcel2.xls]SheetName!Location Cell
C1: R:\Dati\[ClosedExcel3.xls]SheetName!Location Cell
...

is there a way to specify only the name of the files (ClosedExcel1, ...) and then using concatenate to create the full path and then using the full path in a formula like the one you have suggested me?
Thanks