ChrisAcheson
07-10-2017, 09:11 AM
Hi All
My code seems to have broken on the below, in relation to the the word 'format' it worked previously and now has stopped working.
Does anyone know why the below code would now not work, or an alternative suggestion for this below code?
Thanks
ActiveWorkbook.SaveAs Filename:="C:\My Documents\O_S AS OF " & Format(Date, "ddmmyy") & ".xlsx", FileFormat:=51
My code seems to have broken on the below, in relation to the the word 'format' it worked previously and now has stopped working.
Does anyone know why the below code would now not work, or an alternative suggestion for this below code?
Thanks
ActiveWorkbook.SaveAs Filename:="C:\My Documents\O_S AS OF " & Format(Date, "ddmmyy") & ".xlsx", FileFormat:=51