Macro 4 Copying Function Module

  • Thread starter Thread starter Ananth
  • Start date Start date
A

Ananth

I am creating about 60 templates for each of my business units in 60 countries.

The templates has about 30 worksheets.

I have a master template with which I run a macro (called Patch Macro) which
updates the Workbook with country, month, year prefixed files (
UK_04_2009_Branch_Report.xls).

I have created a module that has 6 Functions. I want the templates to carry
this Function Module also.

Can I make the patch macro to copy the Function module in each of the Template
 
Hello Ananth

Ananth wrote:
[..]
I have created a module that has 6 Functions. I want the templates to carry
this Function Module also.

Can I make the patch macro to copy the Function module in each of the Template
Click to expand...

I'm afraid I have no idea, but I'd check this one out in any of the .vba
newsgroups, where you're more likely to get a programming answer.

HTH
Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying toolbars/commandbars 2
How to call module function or sub from the Add In? 3
Macros and Templates Word 2007 4
Templates and Macros 2
Word 2007 macros 5
How to copy rows into an Excel *template* with vba 22
Excel Excel macro to insert template sheet to all files in directory 0
Word 97 to 2007 Macros 2

Back
Top