i have a macro run on a seperate workbook which opens up another workbook.
how can i go about referencing the open workbook to run a command.
i.e i want to change the cell values of A5 on worksheet: "Avg Daily Vol Tab" to the filename (minus the file extension). then save.
on the open workbook.