Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with saveas ftp file problem | Excel Programming | |||
SaveAs Problem | Excel Programming | |||
ActiveWorkbook.SaveAs Problem | Excel Programming | |||
SaveAS w/ a variable name problem | Excel Programming | |||
SaveAs problem | Excel Programming |