ChDir "C:\Users\frank\Desktop\OCIP" ActiveWorkbook.SaveAs Filename:="C:\Users\frank\Desktop\OCIP\LCP.xlsx", _
The file I am saving is called LCP. I would like it to be saved different every time with today's date on it every time I save it. Something like this
LCP - 08-23-2019
Also if it picks up that I am saving it again it can override it without asking me to replace it.
Any help thank you