Accessing External Module

  • Thread starter Thread starter sck352
  • Start date Start date
S

sck352

I have several excel files which are all identical in what they do but
all contain different data (each one is a different year) and they
have to remain separate files. Using a script in a module it populates
each sheet. Works great but the problem is that the modules in all of
the files are identical and whenever i need to change the code, i have
to go into each file and copy/paste the new code in. To run the code
each sheet has a button which activated Sub Populate() in the code. Is
there a way for me to put the code into a separate file in a different
location so that the can all share the same code?

Thanks!
 
hi
yes. put the code in a personal.xls file and put the file in the xlstart
folder so that it will open when excel opens. the personal.xls file is
usually hidden but all macro in the personal.xls file are available for any
file. many users put their personal UDF in thier personal.xls also.

regards
FSt1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change add-in object from within worksheet module. 3
Modules - Save each code in seperate module? or group like code in 1
Pass between modules 7
Passing data to an event handler 3
Breaking User Form Code into modules question 9
Select Case Code does not run... 10
Macro to generate powerpoint slides 43
Excel 2003 - VBA to get a list of Module names in the project 4

Back
Top