Copy Worksheet and Export as .csv

I am exporting about 30 worksheets in my file to a location to store them as csv's. I am looking to add in 2 things to the code:
- applying a color to a few of the rows in the destined csv
- only exporting visible cells into the csv

Please Login or Register  to view this content.

Appreciate the help

As far as I know, csv files are plain text files and therefore colored rows are not permitted.

And where will I list the sheets that I want to export as csv in this code?

There are various methods.

1. Have a unique uniform feature in the name of the files you want to transfer like "2csv...."
you can setup a loop looking for every file with that feature. The feature could also be in the heading setup ie. "Family name1" in the the A column.
2. Setup a master file with all the names and have the macro read it.

I have about 30 worksheets, can you help put in the lines that I need to replace and code that will do that?

I can but we need to define the project.

1. Are all the worksheets in one folder?
2. Are there any other worksheets that need not to be transferred in the same folder (therefore the need of a common trait)
3. What's the ultimate use of the *.csvs
4. Do all transferable worksheets share the same line structure? if not are they to keep the same structure?

lest start with that...