I have a simple copy and paste macro that is activated from workbook A.xls, copies a sheet from b.xls and goes back and pastes it on a sheet "data" in workbook A.xls. So the code to get back to workbook A.xls is "Windows("A.xls").Activate"
The problem is I change the name of the workbook A.xls everyday, as it gets saved with each day's date on it. SO my macro needs to be changed each day.
Is there a command in VBA to go back to the workbook from which the original macro was run from ?
Thanks from a VBA beginner.....