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?
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 by a moderator:
