Save as Macro

[jsantos]

Hi Guys

I am having some problems when putting a macro together that is meant to refresh a used workbook and then save it.
What i am doing is in the end of the week i finish a workbook, and i am doing a macro that clears all the old info and once clear i am trying to save it as "Ticket control week(&Menu!F2).
So the name of the fresh workbook is a set name (Ticket Control Week)with the contents from "F2" in the Menu Tab concatenated.
Could you tell me where i am going wrong, please

Code as follows

Many thanks

ChDir "C:\Users\Bella\Desktop"
    ActiveWorkbook.SaveAs Filename:="C:\Users\Bella\Desktop\Ticket Control Week (&Menu!F2).xls", FileFormat:=xlExcel8,Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False