Macro to generate 1K copy of source csv files with unique value in 2 columns

[mak177]

Hi all,

I am new to VB scripting and required your help.

I want to write a macro to generate 1000 copy of source excel file with unique value in 2 columns.

Source Excel file format:

A B C D E F G H I J K l M
XYZ XYZ XYZ XYZ XYZ
XYZ XYZ XYZ XYZ XYZ Unique XYZ XYZ XYZ XYZ XYZ XYZ Unique

Excel file contain 2 Row.

I want generate 1000 copy of source excel file which contain 2 row as mention above with unique value in cell “F2” and “M2” in each excel and rest all cell values same as source excel.

Unique value can be simple today date like: 08062015_File_1 to 8062015_File_1000 and can be same for both the cell “F2” and “M2”

Thanks

[natefarm]

Excel file contain 2 Row.

Are you saying that you want the 1000 files to only contain one row of data (in row 2), or do you want them to contain all of the data that is on the source sheet, but only row 2 gets changed?

[mak177]

Hi,

I have attached the source excel file.

The source file contains 2 rows and we want to copy both the rows to new 1000 files with same data except for Cell F:2 & M:2 (07082015_0001) where we want unique value in each new file.

[mak177]

Sample excel file format:

2 Rows 13 Columns - Need to generate 1k copy of this source file with unique value at cell F:2 & M:2 for generated 1K files

H	20150808	1800	1	50
D	ASD	ASD123	ZXC	ZXC123	07082015_0001	20150808	20150815		USD	50		07082015_0001

[natefarm]

This should do it. Install the code, adjust the pathname any anything else as needed, and save the workbook as a .xlsm. Run as-is to create 3 workbooks for a test. Then change 3 to 1000, save, and run.

Please Login or Register  to view this content.

[mak177]

Hi Natefarm,

Thanks for your help.

As mention I have changed the path and executed the code.

It successfully generated the 3 files with unique value for cell F:2 & M:2 as required but it is not populating any other static data in remaining cells.

It would be really great if you can suggest if I am doing something wrong here.

Sorry if I didn't explain it properly, I would required all the static data in the 3 new files along with unique value in cell F:2 & M:2 and file to be saved in CSV format if possible.

Thanks

[natefarm]

Please replace the appropriate three lines above with the following:

Please Login or Register  to view this content.