Hi,

I was wondering if someone could help me with programming the following in VB (VB editor in Excell):

I would like to generate all possible solutions to formulae of the form:

a+b+c < X

so if I have for example the number X=3 (my maximum), it would generate the solutions

a=0, b=0, c=0
a=1, b=0, c=0
a=1, b=1, c=0
etc., until all possible combinations of values for a, b, and c that have a summation below 3 are generated. Also it would be great if each of these solutions would then be exported to a .txt file.

Can anyone help me with the code for this?