I have the following line in my macro:
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\admin\Desktop\End of Day\Daily Sales\Daily Sales -" & Range("B1") & ".xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
In Range B1 i have the equation =C2. This cell is in a dd.mm.yyyy format. Cell C2 is a date with dd/mm/yyyy format. I can not save it to what is in cell C2 due to the "/" currently in place. That is why I am trying to save it to the date in cell B2. How can I make this happen?
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\admin\Desktop\End of Day\Daily Sales\Daily Sales -" & Range("B1") & ".xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
In Range B1 i have the equation =C2. This cell is in a dd.mm.yyyy format. Cell C2 is a date with dd/mm/yyyy format. I can not save it to what is in cell C2 due to the "/" currently in place. That is why I am trying to save it to the date in cell B2. How can I make this happen?
