Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
File Save As -Selected Range | Excel Discussion (Misc queries) | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |