How can I save a worksheet from a workbook to another workbook and name it
date saved at using a vb code. And any additional sheet to be saved in the
same workbook.
My aim is to be able to save a stat sheet automatically once a week.

--
Hoyos