script to create csv file from a worksheet in a multi-sheet workbook

I am working on a workbook that imports data from a csv file on sheet 1 when clicking a macro button. (That is done)

On sheet 2 I have the data from sheet one displayed in a user friendly format. An the ability to override data. (That is done)

Then on sheet 3 I have the data from sheet 2 converted back to the format that sheet 1 is in.(That is done)

The last piece I cant figure out is how to make a macro that will parse through sheet 3 and overwrite the original csv file when clicking a button.

Sheet 3 data that needs to be extracted is A3:Y250.

This is an example of what one row in the csv file needs to look like:
0000 -Fee Desc-,0,-1,10,0,0,0,0,220,30,60,100,0,0,0,0,0,100,0,0,0,0,0,0,0

Any help would be greatly appreciated. Even if it isnt in a nice one click automated fashion. I just need to get this data into this format so I can upload it into an application and I am running out of time.


Thanks.

I couldnt get your solution to work (kept getting a runtime error even after changing sheet name) but I was able to do it this way and it works.

The only question I have is if there a way to remove the commas for rows that do not have information in them. For example if A220:250 were blank I would like to have no commas. Right now I am just going to open the file in notepad and remove them but it would be nice to have a file generated that I didn't need to change.

Please Login or Register  to view this content.

jermsalerms,

Please read forum rules below and confirm you understand them. I have wrapped your code for you this time

VBA Noob

jermsalerms,

Thread opened. Thanks for agreeing to follow the rules

VBA Noob