Save as csv

Hi All,

I have the following code (part of it) which works fine on my Office 2010, but kicks out an error message on a colleague's machine who has Office 2007. Can anyone assist with a tweak for Excel 2007, i.e. how to save a worksheet as csv in 2007.

Code:

---

        Workbooks("Journal Upload.xls").Worksheets("Sheet1").SaveAs Filename:="C:\Users\Tony\Journal Upload.csv", FileFormat:=xlCSVWindows

---

Also, after running this macro a number of times, my Excel seems to have slowed and keeps shutting down. I know there is some sort of a cache clean up procedure which could help, can anyone shed any light?

Thanks

H

What if you save the workbook instead of the worksheet ?

instead of

[vba]
Workbooks("Journal Upload.xls").Worksheets("Sheet1").SaveAs
[/vba]

[vba]
Workbooks("Journal Upload.xls").SaveAs
[/vba]