using variables in excel solver constraints problem!

Hi

I've a big problem getting the Constraints in excel solver to use variables.
It seems that the only accepted variable type in the contraints are STRING variables. THe following simple example works AS LONG AS the variable apa is a STRING value and as long as it doesn't contain decimals....

So the question is. How to use varialbes in the FormulaText argement other than string values as integers?

Please Login or Register  to view this content.

Anyone?

How to use a varaible with decimals in the statement:

FormulaText:= ???

What is the syntax and what types are accepted?

thanks!
I've tried the cStr on my variable but it my real sheet the apa variable is actually a cell value (decimal number). Since I'm using the Swedish excel version our numbers use "," instead of "."

IS there simple way of replacing the "," with a "." in VBA?

Ok thanks.
But this won't replace the "," with a "." so that the Solver (VB uses the english way för decimals ".") will udnerstand the string value of a decimal number.

TO clearify what have to be done is.

Replace a number from a sheet (Swedish) such as 3,145 to a STRING (in order to get the solver to understand it) where the "," has been replaced with a "."

Again, thanks Shg for all your support. I've learned som much from you.

Hmm, I've tried the

Please Login or Register  to view this content.

But when used as constraint in SOLVER it's read like

314 INSTEAD of 3.14

What's wrong here?!?!?!

I've got Office 2000 professional

Hmm I've just tried

Please Login or Register  to view this content.

And it's read by excel's SOLVER as 314159!!!!!!!!
I've also tried 3,141559 but it gives the same result....

What is wrong here?? Can office 2000's solver only handle integer contraints labelled as STRING values????!?!?

Please help!!

I get this when I record a Macro using the solver

Please Login or Register  to view this content.

And this code works but ONLY ONCE. When I copy this code into a controlbutton and run IT AGAIN 10,234 is READ like 10234 and "5,543" is read like "5543"

I've tried

Please Login or Register  to view this content.

AND it GET THE SAME RESULT THAT IS 10234...

imAYBY IT'S SOMETHING WRONG WITH THE REFERENCE SOLVER.XLS THAT I USE? CAN IT BE UPDATED?
AGAIN i'VE OFFICE 2000

I don't really understand what this will do. Could you clearify? Best regards

Andy

Hi,

FIrst, here is the macro for creating the model

Please Login or Register  to view this content.

THen I samve the model, start a macro and then load the model

THeis is the code output. As you can see the contratints are not there. Strange or?

Please Login or Register  to view this content.

Does the first piece of code work for you when put into a control button?
a3=a1*a2

thANLS FOR ALL THE HELP SO FAR. thIS PROBLEM IS SO STRANGE...

THe button can be pressed once when the correct values. If pressed again the decimal is not reaad by the solver and the 10,5 is reaad like 105...