Save a range of cells to a file

[gseymour]

Hello,
I am trying to save a portion of a worksheet to a .csv file keeping the same format that is on the original worksheet (ie date formatted mm-dd-yyyy, etc for each column). To start a .csv file is imported to the worksheet and column formatting (insert/delete/move) is done at that time. The input file can vary in row length from file to file but columns are the same 7. I want the range to be captured from a4, lastCol 7 to lastRow, lastCol 7. Most of the columns are text and number but one is a date that has to be mm-dd-yyyy format. I need the output file to be .csv with the data starting in a1 and formatted to keep the already formatted data the same from the original worksheet. Can anyone provide sample code for this?

 

[gseymour]

Well... I finally have code that will export the data to a .csv file but I have two issues. First one is a column is formatted as a date field mm-dd-yyyy in the original file but it is showing as ,#yyyy-mm-dd#, when I view the .csv file and I need it to be ,"mm-dd-yyyy",. I need the correct format and # signs removed. Is there a way to keep the same format? Second issue is a column that has all negative numbers in the original file and I need to have all of the numbers as positives with no $ or commas in the exported .csv file. Can anyone help me?