View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Connie Connie is offline
external usenet poster
 
Posts: 106
Default Save a Range on a Workbook as a CSV File

I have a spreadsheet and would like to save data on a particular sheet
as a CSV file. I'm using the following code to save the entire sheet;
is there a way to only save a certain range of the data? The problem
is that I'm getting commas at the end of the file as well as at the end
of each row.

FName = "Upload" & Format(Now(), "yyyymmmddhhmm")
Sheets("Upload Data").Copy
Set wb = ActiveWorkbook
wb.SaveAs FName & ".csv", FileFormat:=xlCSV
wb.Close SaveChanges:=False
MsgBox "Upload File Saved"

Thanks.

Connie