Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel / VB personal library
hi all,
how i can create a "personal" library with modules i have written, and i use frecuently in different excel applications? now i copy & paste modules from an old excel app to the new one. i think that there must be a more elegant form???? tks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel / VB personal library
Store them in the PERSONAL.xls file which opend automatically with
Excel. If you don't have one already, go to Tools|Macro|Record New Macro and in the Store In field, select Personal Macro Workbook and click OK. Now you can stop the recoding of the macro. We were only using it to create the PERSONAL.xls file. Now you can go into VBE (Alt +F11) and you will see the PERSONAL.xls file in the Project Explorer window. Place your commonly used modules in there and you are good to go. They will be available each time you open Excel. rhXX wrote: hi all, how i can create a "personal" library with modules i have written, and i use frecuently in different excel applications? now i copy & paste modules from an old excel app to the new one. i think that there must be a more elegant form???? tks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel / VB personal library
See
http://www.rondebruin.nl/personal.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rhXX" wrote in message ps.com... hi all, how i can create a "personal" library with modules i have written, and i use frecuently in different excel applications? now i copy & paste modules from an old excel app to the new one. i think that there must be a more elegant form???? tks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Library in Excel | Excel Discussion (Misc queries) | |||
Excel VBA Library | Excel Programming | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
Reference Library - Missing Library in a lower version. | Excel Programming | |||
Excel Library | Excel Programming |