Solver Questions

P

pb1

I am not new to Excel, but I am very new to functionality outside o
functions such as SUM and VLOOKUP.

One of the areas I support has an Excel Spreadsheet, which was built b
someone else, that uses Solver. This is something totally new to me.
I did not even know about it until a few minutes ago.

The area that uses the Solver Add-In uses it for several workbook
within the spreadsheet. Can a Macro be written so the user does no
need to go through each workbook.?

Where can I go for more help on this? I have not written a Macr
before, but I do have VB experience.

Thanks

Pa
 
B

Bernard Liengme

Hi Pam,
Without knowing exactly what Solver does in each worksheet it is hard to be
definitive. But in general you can write a macro to call Solver. I believe
there is a KB document at the Microsoft website. You may also want to visit
www.solver.com to learn more about Solver.
Best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top