how to save multiples copies of a workbook

[Excelrookie_1]

Hi There,

I need help in writing a macro which copies data from a source file paste it in another file and save that file as a separate workbook. Data in the source file is stored in two columns with multiple rows. Macro needs to copy data in each row of both columns, paste it in a workbook and save a copy of it as a separate file. This process needs to continue for each row.

Let me know if any further details are required.

Regards

[brynbaker]

So I understand you want a number or workbooks, one per row in the source, each book containing only two cells taken from the 2 source columns.

Please Login or Register  to view this content.

(Untested)

[Excelrookie_1]

Thank you for the above code, i just need one more help. I need to prompt the user to select a folder once and save all the processed files in that folder one after the other. can you guide me on how to code this.

Thanks in advance

[brynbaker]

It possibly depends on how you develop the filenames for each file.
In principle you can do chdir(foldername) once you've done the initial prompt, then if you don't include a path name in the saveas, they will all go thee.
Here's one approach:

Please Login or Register  to view this content.