VBA code to save only text with quote marks in a CSV

Hi,

I have a 10 column worksheet with text in the first 9 columns (A to I) and a number in column 10 (J).

I need to save this as a CSV with quote marks around the data in the first 9 columns and without quotes around the number in column 10.

Found the attached macro code on the MS site, however it saves the data in all columns with quote marks. Can someone help with modifying it so it will do what I require?

Please Login or Register  to view this content.

Thanks
Alan

Please post the code directly to the forum, not in a txt file attachment.
Use code tags: [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Also attach a sample of the data the macro operates on.

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Please Login or Register  to view this content.