Macro in Excel to get values from a clos

Is there a way to program a macro which gets values from other excel files without opening the other excel files ? I ve tried to use the ADO function , but cant figure it out. Any assistance is appreciated