The relevant section of code I have is:
' Get objective from cell D3
solv.Objective = Sheet.getCellByPosition(3,2).CellAddress ' does not work with the uno call
solv.Maximize = False
solv.Solve() 'Seems to work and indicates the correct value but was not saving values
' dispatcher.executeDispatch(document, ".uno:SolverDialog", "", 0, Array()) 'uno call works to start solver but does not set constraints or objective
I would value any assistance
Edit: Split from Solver macro; This situation is different and needs a new topic |