kato01
Full Member level 2
I am trying to run HFSS from EXCEL and use the SOLVE optimizer.
I created amodule tht opens HFSS, change variables, runs HFSS, export results and calculate a goal function.
Say, this function is
function Fun(x)
Then in sheet1, i have in cell C3=Fun(B3)
Even though the Fun(B3) is a number, the C3 cell gives me an error (#Value). So I can't use the solver
If anybody has a working example I would appriciate
I created amodule tht opens HFSS, change variables, runs HFSS, export results and calculate a goal function.
Say, this function is
function Fun(x)
Then in sheet1, i have in cell C3=Fun(B3)
Even though the Fun(B3) is a number, the C3 cell gives me an error (#Value). So I can't use the solver
If anybody has a working example I would appriciate