how does one read/copy data from a closed workbook (without opening it?)?
At present I am using code as follows, but don't wish to open the workbook.
Set SrcWbk = Workbooks.Open("L:\Backup\BE.xlsx", , , , "test")
Set SrcSht = SrcWbk.Worksheets("Sheet1")