Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBAHow to populate a new workboook with the existing formatting?

Status
Not open for further replies.

xstyle00

Technical User
Jun 13, 2007
2
NZ
Hi,

I need to populate the 100 new workbooks with the same formatting (Header, color, combobox, fomular and etc.).

How to do that?

CheerZ
Xstyle


 
Thanks

The situation is not that simple.
I have designed my template which contains combo boxes, module and etc.

Now I have to populate my template with 100+ copies with same format but for different groups.

It means that each new workbook has to have same formatting (i.e. headings, column width, colour and etc.) but with different group name and other related feature (e.g. group code, FTE no., total expenditure, and etc.) according to the cost centre, which would be provided in the reference table.

I dont think Saveas would solve my problem.

Many thanks



 



Where is the Source Data?

What discriminates the groups?



Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top