How do I save a file with decimal number

[soeo22]

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.

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[soeo22]

Thank you so much, it works exactly the way I want it.


: