Re: Read Text From A Closed Workbook
I use the function “ExecuteExcel4Macro” in a fashion similar to the following:
Code
Sub GetData
Dim Path As String
Path = "'C:\Excel Documents\[Raw Data.xls]DataSheetNm'!"
Range("A1").Value = ExecuteExcel4Macro(Path & "DefinedNm")
End Sub
"DefinedNm" is a defined name I have given to the cell that I'm extracting data from in the closed workbook.