Thread: Saving a sheet in a workbook as .csv but not changing workbook name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kaak[_42_] Kaak[_42_] is offline
external usenet poster
  
Posts: 1
Default Saving a sheet in a workbook as .csv but not changing workbook name

Sheets("Data").Select
Sheets("Data").Copy


ActiveWorkbook.SaveAs Filename:= _
"C:\Data.csv", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
_
CreateBackup:=False

ActiveWindow.Close


--
Kaak
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=480090

Reply With QuoteReply With Quote