I need to solve a equation using excel solver from visual basic 6. i did it manually in excel and recorded tha macro. however when i trid to automate excel using vb, an error message is displayed. it highlights the solverok function and says function not valid.
can someone please tell me whats the problem or how do i automate excel solver using vb6.
any help will be appreciated.