ActiveWorkbook.SaveAs Filename:="C:\Gordstuff\" & _
Format(Date - 1, "mm-dd-") & _
Format(Sheets("Sheet6").Range("A3"), "$#,##0.00") & ".xls"


Gord Dibben MS Excel MVP


On Sun, 20 Sep 2009 11:43:01 -0700, soeo22
wrote:

Hi,
I try to run macro to save a csv download file with filename as yesterday
and a last cell on excel sheet which has formula sum up in column. such as
09-19-$3659.45, SAVE AS normal excel file, but the saved filename display
only 09-19-$3659 and without two decimal or with decimal but file icon is not
an excel icon. I can't get it work correctly. Can any help on this?
Thanks in advance.