Dynamic code changes

[Ray Bailey]

Hi,

I have a number of functions to calculate financial periods, rates, target dates etc. which I have in a single .bas file. These functions are used by a dozen macros and various users.

My issue is that if I need to change a function, I have to replace the module in each of the macros and then re-distribute them.

Is there an easy way of handling this. I did look at loading the module from within the VBA could, with little success. Is there a Use or Include type of command as in some other languages.

I think that I should be able to use an add-in (xlsa) file but our IT dept have already said that I'm not allowed to do that.

Any advise will be gratefully received.

 

[James006]

Hi Ray,

Always nice to hear that one has to progress ...DESPITE ... the IT dept ...:wink:

It seems to me ... you need to jump onto the VBE bandwagon ...

Take a look at the excellent explanation done by Chip ...!!!

http://www.cpearson.com/excel/vbe.aspx

Hope this will help

 

[Ray Bailey]

Thanks James,

Had a quick look and seems very interesting, I'll give it a go later.

Got more programming years under my belt than I care to remember, but processes have to be followed etc.

Cheers

Ray