Report Generator

[BukiSP84]

Hello! I am currently working on an Excel workbook that may be able to produce financial reporting templates, based on the data taken from the contract.
Namely, not all contracts are the same. Most of them differ in budgets, many of them in a number of reports etc.
To accomplish my task, I have inputs sheets. Resulting from input sheets, parameter sheets are created.
I've managed to code many of them. Now, I am stuck with the reporting template, itself.
So far, doing good. Now, I face a challenging need to have a couple of nested for each statement. I don't see other way around, considering my VBA knowledge.

What is your approach in a similar situation? Do you call individual macros, or put everything into one?
Calling individual macros would resolve my problems. However, I am pretty much lazy about resetting.

Aside of defining global variables and constants, is there a way to set values applicable for all modules & sheets?

For example:

Dim InputSheet as Worksheet
Set InputSheet = Worksheets ("InputSheet")

for all modules & worksheets to be implemented, not to reiterate sub by sub?

 

[Joe4]

Your question is a bit high-level/generic, so I don't know how much this will help, but here goes.
Typically, when I have large projects with a lot of code and a lot of repitition, I like to break my code into numerous, smaller sub procedures.
In the interest of keeping things generic and dynamic, so I can easily re-use my code, I will often use parameters that I can pass to the sub-procedures.
(If you find yourself creating multiple similar sub procedures, that is usually a sign that you can change your approach to just using one sub procedure for that part and pass in the changing values that you need).

Here is a good link on doing that (note that "parameters" are also often called "arguments"):

Microsoft Excel VBA Procedures: Arguments and Parameters