Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy a new module to 200 workbooks with a macro?
I have created a new module in my master budget workbook for a custom Excel
function that I would like to copy to another 200 existing budget workbooks, to enable them to use this new function. I intend to distribute the workbooks to about 10 different people for them to complete their budgets. Each workbook needs to have both the new module and the new function. How do I do that? Thanks, Patrick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I copy a new module to 200 workbooks with a macro?
You shouldn't. Distributing code inside of workbooks that contain data
is a bad idea. Instead, create an add-in. Start with Microsoft Office XP Developer Building Application-Specific Add-ins http://msdn.microsoft.com/library/de...l=/library/en- us/modcore/html/deovrbuildingapplicationspecificaddins.asp and Microsoft Office XP Developer Add-ins, Templates, Wizards, and Libraries http://msdn.microsoft.com/library/de...l=/library/en- us/modcore/html/deovraddinstemplateswizardslibraries.asp -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , pyoung129 @comcast.net says... I have created a new module in my master budget workbook for a custom Excel function that I would like to copy to another 200 existing budget workbooks, to enable them to use this new function. I intend to distribute the workbooks to about 10 different people for them to complete their budgets. Each workbook needs to have both the new module and the new function. How do I do that? Thanks, Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for copy-pasting from different workbooks | Excel Worksheet Functions | |||
How do I copy a new module to 200 workbooks with a macro? | Excel Worksheet Functions | |||
copy text between 2 open workbooks via macro | Excel Worksheet Functions | |||
Macro to copy and paste between two workbooks | Excel Programming | |||
macro to copy and paste between 2 workbooks | Excel Programming |