Generate excel workbooks based on excel list

Solved/Closed
m_albges
Posts
5
Registration date
Thursday February 21, 2013
Status
Member
Last seen
May 9, 2013
- Feb 21, 2013 at 07:03 AM
 rivera - Jan 16, 2017 at 04:36 AM
Hello,

I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel. So if column A says 'AC.334.997' and column B says 'Process improvement project', it would generate workbooks based on the template - in this case named 'AC.334.997_Process improvement project', and so on.

Any help would be much appreciated!

Thanks,
Matt.

Related:

6 replies

m_albges
Posts
5
Registration date
Thursday February 21, 2013
Status
Member
Last seen
May 9, 2013
11
Feb 21, 2013 at 11:55 AM
Hi Trowa - great work!

This works well - the only issue is that each workbook it creates is a duplicate of the original list whereas what I need is for each workbook to be a given template... any idea how to do that?

Could I specify a template or a location of a file that it will then take as a sample and copy for each individual file that it creates?

Many Thanks!
Matt.
11