Save Range as CSV and update range format in CSV before saving.

**Hyperion1571** · 09-24-2021, 03:34 AM

Hello all,

I have the below code however i need to edit the CSV data before it saves as currently the copy and past section looses the formating.

Please Login or Register  to view this content.

This is the section that im looking to do in the CSV the following

Please Login or Register  to view this content.

Thanks for your help.

**davsth** · 09-24-2021, 04:15 AM

A sample workbook would be much clear with what you want to achieve. see the yellow banner

You are pasting as values with no formatting and losing formatting. Are you trying to repeat the formats from the original document? If so why not paste the formats as well?

**jindon** · 09-24-2021, 04:19 AM

If the original data is formatted properly then just try remove xlPasteValues.

**Hyperion1571** · 09-24-2021, 04:22 AM

Thanks Jindon, The data in the origional document it correct but is prone to other users changing headings or format. What im attempting to do is merge the first and second set of code into one macro so the process would be,
Copy and Past range from core document to new document > Edit Formating and headings > Save under the new file name.

Thanks in advance.

**jindon** · 09-24-2021, 04:29 AM

If you want to combine 2 codes then should be look like(untested)

Please Login or Register  to view this content.

**Hyperion1571** · 09-24-2021, 04:45 AM

Thanks jindon
All seems to work however the date format still comes up as UK Date "dd/mm/yyyy" cont figure out why it doesnt conform to the format stated

**jindon** · 09-24-2021, 04:46 AM

That means that column is Text date, not Serial date, I guess.

Or just realized that "Date" Column is "E" in new workbook...

Save Range as CSV and update range format in CSV before saving.

LinkBack

Thread Tools

Rate This Thread

Display

Save Range as CSV and update range format in CSV before saving.

Re: Save Range as CSV and update range format in CSV before saving.

Re: Save Range as CSV and update range format in CSV before saving.

Re: Save Range as CSV and update range format in CSV before saving.

Re: Save Range as CSV and update range format in CSV before saving.

Re: Save Range as CSV and update range format in CSV before saving.

Re: Save Range as CSV and update range format in CSV before saving.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Save and restore (or transfer) a range's format properties

[SOLVED] Saving a range of excel cells as a script file (scr.) without "Save As" prompt screen

extract a list from a range that meet criteria and update chart format dynamically

[SOLVED] Saving a specific cell range in a pdf format

[SOLVED] Saving range of cells in a PDF format using a button on excel worksheet

[SOLVED] Save selected range in a pdf format & email the file to a someone automatically?

[SOLVED] Save a range to binary file (including its format)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions