Hi,

I wish to save down a particular workbook to a particular path with an exact name and yesterday's date.

91 Daily Revenue 13 05 2019_KM

I wish to save the file as the above, but with the current variables constantly updating.

91 represents the current workday in the year and the date save down as the previous days date.

My current code only saves a blank workbook in the below path.

I searched all websites but couldn't find anything that matches my exact requirements.

Sub SaveWorkbookSet()


Dim wkb As Workbook
Set wkb = Workbooks.Add


wkb.SaveAs "N:\My Documents\Daily Revenue.xls"


Worksheets("Control").Cells(31, 5) = Now