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.

 

[Andrew]

Try adding the .XLS extension..!
eg.. 09-19-$3659.45.XLS

HTH

| 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.


: