Public Sub Save()
ThisFile = Range("G4").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
Im trying to get this macro to save a spreadsheet under the name of the value that is in g4, in G4 however is a formula that calculates the date "=today()" and when i implement the macro i get a error stating it wont save. if anyone has any ideas id be most greatfull.
ThisFile = Range("G4").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub
Im trying to get this macro to save a spreadsheet under the name of the value that is in g4, in G4 however is a formula that calculates the date "=today()" and when i implement the macro i get a error stating it wont save. if anyone has any ideas id be most greatfull.