Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Common module by multiple workbooks
I have a number of workbooks (say 30) that all have one module wit exactly the same code in them. Every time I make some changes in th code, I have to update all workbooks. *Is there a way to use one common module which will be someho called/referenced by all workbooks?* Thank -- S@ ----------------------------------------------------------------------- S@S's Profile: http://www.excelforum.com/member.php...fo&userid=1606 View this thread: http://www.excelforum.com/showthread.php?threadid=27519 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Common module by multiple workbooks
Save the code in your Personal.xls, which is saved in your xlstart folder.
If the file doesn't exist, create one. Whenever you open Excel, the personal.xls file in folder xlstart will open and be hidden. However, you can see it in the VB Editor projects. Any macro in your Personal.xls will now be available for any open workbook to use. Mike F "S@S" wrote in message ... I have a number of workbooks (say 30) that all have one module with exactly the same code in them. Every time I make some changes in the code, I have to update all workbooks. *Is there a way to use one common module which will be somehow called/referenced by all workbooks?* Thanks -- S@S ------------------------------------------------------------------------ S@S's Profile: http://www.excelforum.com/member.php...o&userid=16062 View this thread: http://www.excelforum.com/showthread...hreadid=275190 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros common to several workbooks | Excel Worksheet Functions | |||
VLOOKUP-common look up entry with multiple results | Excel Worksheet Functions | |||
Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
How do I copy a new module to 200 workbooks with a macro? | Excel Worksheet Functions | |||
Excel: how to merge data from 2 workbooks with 1 col. in common? | Excel Discussion (Misc queries) |