excel / VB personal library

[rhXX]

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

 

[JW]

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.

 

[Ron de Bruin]

See
http://www.rondebruin.nl/personal.htm