Generate workbooks for each day of month

[Sprucy]

Hi Everyone,

Just read your Q&A and thought maybe one of you can help me out.

I'm using Workbook-AA as a template... Users open the AA.xls, types in the date in D2, runs a macro which renames the Workbook as 12/31/05_AA.xls (you guest it... a concatenate formula in cell A1 that captured the date in D2 and the desired AA from cell D3 [to refer to the initial AA template]).

How do I write or add a macro that you generate all 28-31 days of the month in one shot? As it is, we do this 31 times (Jan, Mar, etc) to generate 1 workbook for each day.

Any ideas?

Cheers,
Sprucy

 

[Von Pookie]

You would do better to post this as a separate question. I will go ahead and separate it from this thread and make it a new one