Splitting code to modules ... HOW ?

  • Thread starter Thread starter roelm
  • Start date Start date
R

roelm

I have build several Excel VBA applictions, but many of them use som
same code and functions. I like to put the code into ONE base module.
How must I create the module, export it ? And how to refer to it in al
the programs I like to use the base module ??

Roel
 
Roel

If the macros are in several workbooks copy them into the
same book and save this as Personal.xls The personal
workbook may not be visible when you start Excel but the
macros will be available to all workbooks.

Alteratively, save the macro as an addin
e.g. "myFile.xla". AddIns have to be installed Tools,
Addins Your file "myFile" will appear on the list. Click
the checkmark to install the addin. The xls file will
still exist and be available to edit or add new macros but
you wil have to save the xla file as well.

Regards
Peter
 
It's not clear to me. I don't use macro's, but just code.
And I want to put common functions and procedures in one file and
include this file into my project.
When I change code to the common files, all the projects using this
code, have to use the new code.
 
Back
Top