Split a File to Multiple files with Selected columns into CSV format

Hi,

Would like to split a files into multiple files of 1700 rows which is working in current VBA code attached which I have found in the website.

Would like to makes changes in the VBA :
1) Populate selected columns of A to G only in the split files
2) Adjust column width automatically
3) Save in csv format (Currently VBA saving in xls file)

I'm new to VBA and would like to have your assistance in amending the VBA code.

Thank you.

You could try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

Hi,
I have Test the data. It working great for csv format and the column width.
I have column until column H. However,would like to populate selected data from column A until column F only.

Would like your advise on how to go about adding into the attached VBA as well? Thank you.