| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding a module to several different workbooks
Is there a way to add a module (with a macro) to several workbooks...without
doing by importing file by file..?TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a module to several different workbooks
Open all of you workbooks, and in the VBE, just drag and drop from the
source workbook to each target workbook. -- HTH RP (remove nothere from the email address if mailing direct) "uriel78" wrote in message ... Is there a way to add a module (with a macro) to several workbooks...without doing by importing file by file..?TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a module to several different workbooks
I meant to add
But shouldn't you avoid all that code replication, and put it in one place, like an add-in? -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... Open all of you workbooks, and in the VBE, just drag and drop from the source workbook to each target workbook. -- HTH RP (remove nothere from the email address if mailing direct) "uriel78" wrote in message ... Is there a way to add a module (with a macro) to several workbooks...without doing by importing file by file..?TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding a module to several different workbooks
THat's a good solution but I can't do it....I'm not very good at using excel
& VBA... "Bob Phillips" ha scritto nel messaggio ... I meant to add But shouldn't you avoid all that code replication, and put it in one place, like an add-in? -- HTH RP (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... Open all of you workbooks, and in the VBE, just drag and drop from the source workbook to each target workbook. -- HTH RP (remove nothere from the email address if mailing direct) "uriel78" wrote in message ... Is there a way to add a module (with a macro) to several workbooks...without doing by importing file by file..?TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a new module to 200 workbooks with a macro? | Excel Worksheet Functions | |||
| Common module by multiple workbooks | Excel Programming | |||
| Common module by multiple workbooks | Excel Programming | |||
| Adding module - assigning macro to button | Excel Programming | |||
| Adding Code Module to Workbook | Excel Programming | |||
Hybrid Mode
