Wrong Number or Arguments / Invalid Property Assignment error

[NinaE_11]

Perhaps this is something silly I'm missing, and if any one could point it out - I'd be very grateful. I'm attempting to save a copy of worksheet, with the given file name formatting below, but I get an error on the word "Format" in the fileday row. This exact language works in another workbook I have (I copied over in it's entirety), but VBA seems to choke on the underlined word below. Any insight would be appreciated - thank you!

'Create the filename with today's date and time in the filename

filePrefix = "Taiko"

fileDay = Format(Day(Now()), "00")

fileMonth = Format(Month(Now()), "00")

fileYear = Format(Year(Now()), "0000")

filenameOutput = filePrefix & " " & fileYear & " " & fileMonth & " " & fileDay

filenameLongXLSX = Application.ActiveWorkbook.Path & "\" & filenameOutput & ".xlsx"

 

[Fluff]

This exact language works in another workbook I have

That suggests that in the workbook where it doesn't work, you have a procedure of variable called Format.