I have a simulation tool that's made in Excel VBA which I need to run for a large range of input parameters values.
The VBA code is password protected and I can't access it. I can only fill in the inputs and click the simulate button.

The tool takes 8 input parameters (green) and spits out between 1 and 14 different outputs (red, which depends on the input parameters).
I need to run the tool for a set of different input parameters values.
The first two will always be 1, but the 3rd for example can be [1, 2, 3, 4, 5, 6, 7] and the fourth one can be [1, 2, 3, 4, 5, 6, 7, 8, 9, 10], etc.

Wondering if it's possible to write a script for this to automate it.
Doesn't matter which language it is in. I might also be able to aqcuire this simulation toon in python format soon.

Willing to pay well for this if it's even doable.

Here's two examples of different runs with different parameters (3rd parameter was changed from 2 to 3).






The final output should look like this:

are you seriously asking someone to reverse this calculation by providing exactly no useful information at all?

if you don't know any of the rules behind the calculation, your best bet is to bruteforce the password protection or start getting familiar with neural networks

This post was edited by Klexmoo on Nov 27 2020 01:23pm

Wut

I need some sort of a script that will fill in the input parameters (e.g. 1,1,1,1,1), hit the simulate button and then store the output of this tool. Then it fills in (2,1,1,1,1), Then (3,1,1,1,1). Etc

I know the calculation behind the tool, it’s a simple (R, s, nQ) inventory control policy.

Could you share the desired calculation? It would be simple to write something to loop through possible input values and read outputs, but in your case I'm not sure you'd be able to interact the button or run the associated subroutine so I don't know if that's even an option.

Apparently it wasn't too hard to bypass the password so it's possible to view and edit the code behind the button now.

Does that help? Surely you could make a loop for different input parameters now and have the output stored with just 1 single click on the button?