VBA .xlam for multiple workbooks

amarokWPcom

New Member
Joined
May 30, 2019
Messages
25
Good morning,

I have several tools working with which include sometimes the same Subs .

So everytime I found an effort on one Sub and change it in one workbook I repeat this in the other workbooks.

Wasting time - isn’t it?

I want to have one workbook with all Subs inside, soft coded. So they get all variables from the actual workbook I working with.



To keep the code transparent and small I would like to have the start Sub in the actual workbook and Call the necessary Subs out from that.

I would like to have the declaration of the variables and also the setting/filling of the variables only in the starting Sub. Unfortunately only the declaration works but the setting I have to write in every Sub in the .xlam file.

Are their any better ways for this probably for the complete workflow?
 
Last edited:

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,089,201
Messages
5,406,810
Members
403,106
Latest member
AliO

This Week's Hot Topics

Top