|Hi Mike, |
many thanks for your reply.
I have tried to remove all the " " to "". Unfortunately it does not seem to work.
In the first row of my WS I have data in col A-D in the row 2 I have data from A-M. When I save as csv, the csv file will show 9 extra commas in the first row. I need to import the file into another system therefore I need to remove the commas.
I do not want to have to enter word pad and manually delete these commas. I have been reading up on this and from what i undersand there is some VB code that can be used to stop this.
I have a VERY simple macro to save as csv.
Sheet3.SaveAs Filename:="H:\" & Worksheets("Customer Account").Range("B1") & ".csv", _
Is there anything I can add to this code that will get rid of the extra commas?
Any tips will be greatly appreciated.