Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vendor Sourcing Tool
Hi all,
I'm developing a tool which minimizes the total sourcing cost and delivery lead times provided with some constraints. So i'm calling Excel Solver from VBA. But, I'm getting the following error when i call solver from VBA. "Solver: An unexpected internal error occured, or available memory was exhausted." I use excel 2000 SP3 version. Is there any way to get rid of this problem? If in case this could not be solved, how far is it feasible to write a code to solve the minimization Linear Programming problem instead of going for Solver? (I wonder would that be a great task to do as I'm new to VBA and i'm learning a lot from this discussion group). Pls guide me in the right path. Thanks a lot in advance. Madhavan.R |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vendor matches | Excel Worksheet Functions | |||
Vendor List | Excel Worksheet Functions | |||
Vendor Lookup | Excel Worksheet Functions | |||
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
Creating a Vendor ID from Vendor Name... | Excel Worksheet Functions |