Excel 2007 VBA Error #450

Hi

I have created a macro that works perfectly in 2010 but when I try to run 2007 it pops up an error message "Run-time error '450' Wrong number of arguments or invalid property assignment'. I use solver addin - I have attached the excel file - In that sheet called "Multilinesup" and the macro button is "Run Optimizer".

Please help.

I'm unable to upload the file here as it exceeds 1 MB so below is the direct link

http://excelbyjoe.com/MEF/wp-content...s-v3-2007.xlsm

Thanks
Thiru

Looking at your macro you call Engine 2 i.e the "Simplex Model" but only in excel 2010 and later you have 3 different models for solver. For excel 2007 and 2003 you can only select select a linear or a non liner model (see options excel 2007) this is why you get an error message "ivalid property assignment"

To fix this you need to remover the "2" and the "Simplex LP" from the line

Please Login or Register  to view this content.

and probably add a line like this:

Please Login or Register  to view this content.

Still I'm not sure the excel 2007 solver is powerfull enough to solve this problem. My best advice to you would be to install the "OpenSolver" as this intergrates nicely into excel 2003, 2007 and 2010.

This is a free program developed by the University of Auckland, NZ and a much more powerfull solver than the excel one. Still it only solves linear problems but that should not be a problem in your case.

Alf

Ps sorry it took some time before I could help you with you problem but I've been away for some time.