Maybe you could just copy that sheet to a new workbook, then save it there and
finally close that new workbook:

sheet2.copy
activeworkbook.saveas "C:\oko", xlCSV
activeworkbook.close savechanges:=false



pittur wrote:

I'm using a simple Macro to save a workbook as CSV but the file is never
saved. The code runs fine but nothing happens

Sheet2.SaveAs "C:\oko", xlCSV

I have tried different version of this code but nope.

I'm using Office XP and the funny thing is that this seems to run fine
on Office 2002.

Pittur.

--
pittur
------------------------------------------------------------------------
pittur's Profile: http://www.excelforum.com/member.php...o&userid=24363
View this thread: http://www.excelforum.com/showthread...hreadid=379603

--

Dave Peterson