Solver, macros Excel
 

Hi
I need to know how can i use the solver's function from a macro without
reciving the follow menssage: "Compile Error: Sub or function not
indentified". I opened the VBA reference dialogue box, and i checked
SOLVER boxe. And i have, in the "reference folder" REFERENCE to
SOLVER.XLA, but when i run my project i recive the menssage. I don't
know what i'm doing wrong, may i have to anything else, somebody can
help me???????????????


--
scaroca
------------------------------------------------------------------------
scaroca's Profile: http://www.excelforum.com/member.php...o&userid=26992
View this thread: http://www.excelforum.com/showthread...hreadid=401983

Getting VBA to talk to add-ins is a pain in general. Look at sisco98's
posting in 6/1/2005 in microsoft.public.excel.worksheet.functions for advise
on the same problem.
--
Gary''s Student


"scaroca" wrote:


Hi
I need to know how can i use the solver's function from a macro without
reciving the follow menssage: "Compile Error: Sub or function not
indentified". I opened the VBA reference dialogue box, and i checked
SOLVER boxe. And i have, in the "reference folder" REFERENCE to
SOLVER.XLA, but when i run my project i recive the menssage. I don't
know what i'm doing wrong, may i have to anything else, somebody can
help me???????????????


--
scaroca
------------------------------------------------------------------------
scaroca's Profile: http://www.excelforum.com/member.php...o&userid=26992
View this thread: http://www.excelforum.com/showthread...hreadid=401983

What is the line that the VBE pointing to when it complains of the
unknown procedure?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Hi
I need to know how can i use the solver's function from a macro without
reciving the follow menssage: "Compile Error: Sub or function not
indentified". I opened the VBA reference dialogue box, and i checked
SOLVER boxe. And i have, in the "reference folder" REFERENCE to
SOLVER.XLA, but when i run my project i recive the menssage. I don't
know what i'm doing wrong, may i have to anything else, somebody can
help me???????????????


--
scaroca
------------------------------------------------------------------------
scaroca's Profile: http://www.excelforum.com/member.php...o&userid=26992
View this thread: http://www.excelforum.com/showthread...hreadid=401983