I have a macro, that I want to reference a cell from an open workbook. How can i do this?
in the VBA, I want the value of L87 on "F&O Daily" to be the value of open workbook: "F&O Daily" A98 + ".xlsx" (A98 lists the workbook name that would be opened), B5 (on the A98 workbook).
i.e A98 on F&O Daily will say: "March 9 2015". The open workbook I want to ref would be March 9 2015.xlsx. I'd then want to use the data from B5 within this opened workbook. (on worksheet named: "Avg Daily Vol")
With Sheets("F&O Daily")
'want to insert cell ref here