Export To Inf file & Zip the Files from the given file paths picking every 10 rows

Hi Excelians ,

Hope all members are doing well.

I have seen many threads asking for macro to export data to a csv or txt or inf but my query involves more.

I have a data which needs to be exported as inf files (CSV with '&' as a deliminator with extension as inf) & also files to be zipped as per mentioned file paths in the same excel.

Now the twist is I need to do the above in pack of 10 rows avoiding empty rows. INF data rows should be limited to 18 columns only, no empty colums beyond it.

It should pick up 1st 10 rows export inf data & zip 10 files by refering the file paths mentioned & then pickup next 10 rows & do the same till the data ends.

I have attached the data excel for your reference.

Please let me know if you guys have any further queries.

PLS HELP ME OUT FELLOW MEMBERS !!!!!


THANKS,

VIVEK