Easy one: Saving a Workbook

[Submersed]

Hi All,

I am trying to save a workbook using this code:

ActiveWorkbook.SaveAs "D:\Test\Testing " & Cells(5, 1) & Cells(5, 9) & ".xlsm", FileFormat:=52

It saves but then comes up with error 1004? anyone know why this is?

Thanks

 

[Submersed]

Edit: It does not save, but it does rename the title of the workbook

 

[Submersed]

How do you save a workbook? this isn't making sense to me! I am using Excel 2007 and need to save it as .xlsm

am I doing something wrong?!