ActiveWorkbook.SaveAs

[fmardani]

Hi,

The error is:
Wrong number of arguments or invalid property assignment
It seems the format code is wrong?

What is wrong with this code please?

ActiveWorkbook.SaveAs Filename:= _

"G:\MarketRisk\DailyReport\GlobalMarketsRiskReport" & Format(Range("ReportDate").Value, "ddmmyyyy") & "xls", _

FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False

[mudraker]

Please take a couple of minutes to read the forum rules & wrap your VBA code

See link below for forum rules

To wrap you Vba code use the # icon

[mudraker]

I can see nothing wrong with your code aslong as the named range is on the activesheet. The range is a single cell and contains a date. The path listed is a valid path