How do I read data in another opened excel document (in a certain sheet without activating it
E Ernest Aug 24, 2005 #1 How do I read data in another opened excel document (in a certain sheet without activating it
D Duke Carey Aug 24, 2005 #2 By "read" do you mean link it into the active workbook? Use a link formula: ='[Other Book.xls]Sheet1'!$A$1
By "read" do you mean link it into the active workbook? Use a link formula: ='[Other Book.xls]Sheet1'!$A$1
