+ Reply to Thread
Results 1 to 53 of 53

Solver, macros Excel

  1. #1
    Registered User
    Join Date
    09-05-2005
    Posts
    1

    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???????????????

  2. #2
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  3. #3
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  4. #4
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  5. #5
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  6. #6
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  7. #7
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  8. #8
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  9. #9
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  10. #10
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  11. #11
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  12. #12
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  13. #13
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  14. #14
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  15. #15
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  16. #16
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  17. #17
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  18. #18
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  19. #19
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  20. #20
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  21. #21
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  22. #22
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  23. #23
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  24. #24
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  25. #25
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  26. #26
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  27. #27
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  28. #28
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  29. #29
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  30. #30
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  31. #31
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  32. #32
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  33. #33
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  34. #34
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  35. #35
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  36. #36
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  37. #37
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  38. #38
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  39. #39
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  40. #40
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  41. #41
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  42. #42
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  43. #43
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  44. #44
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  45. #45
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  46. #46
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  47. #47
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  48. #48
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  49. #49
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  50. #50
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


  51. #51
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  52. #52
    Gary''s Student
    Guest

    RE: Solver, macros Excel

    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
    >
    >


  53. #53
    Tushar Mehta
    Guest

    Re: Solver, macros Excel

    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 <scaroca.1uwjic_1125950707.67@excelforum-nospam.com>,
    scaroca.1uwjic_1125950707.67@excelforum-nospam.com 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
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1