Save as VBA Excel
Posted on 2014-03-14
Can you please help,
I'm trying to save the sheet (range) as a cell value.
but I keep getting error.
example,, Cell c2 is
Orders Count_between (02/01/14 _ 02/28/14)
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Wassim.\Desktop\" & Range("C1") & ."xlsx", FileFormat:=51, CreateBackup:=False
Thank you for your help,