Excel Macro "Memory exhausted"

[Torsten Labs]

I try to start an Excel Macro and everytime when i started it, comes a message like that: Solver: An unexspected internal error occurred, or available memory was exhausted"

I try to start the Excel Solver Function with a macro from Labview. I use Excel 2003 and Labview 7.1.

Thx for help

Torsten

[Michael_Munroe]

Solver is an AddIn that is not installed in a typical Excel installation. If you attempt to run it from the menu, it will prompt that it needs to be installed. This could be what is causing this error. Run the Solver from the menu and check that it is able to run manually.

After that, check the parameters carefully to make sure that you are not giving the Solver a bad cell reference or an invalid parameter.

Michael Munroe
www.abcdef.biz

[a3j]

I had the same problem when LabVIEW ran the Excel Macro with Solver (Excel 2002 or 2003 and LabVIEW 7.1).
The Maco could be run manually from MS Excel without any errors.

I guess it is the LabVIEW problem. Have you got the solution yet? Does anyone have the solution?

Thanks,
a3j

[Brett_B.]

Could someone post a small piece of code that creates this error. I have LV7.1 and Excel 2003 and I would like to take a look at it.

-Brett Burger

[a3j]

Here is a piece of code to generate the error code.

[a3j]

Here is a piece of code to generate the error code.

[Timothy_Wright]

When I downloaded the excel file it had no macros embedded. Was this a mistake, or is my antivirus doing a much better job "protecting" my computer than I thought?

[a3j]

Let's try it again. For some reason, when I attached the Solver_SimpleTest.xls, the macro was gone.

[a3j]

Finally, I got the problem solved. It's not the LV problem. The problem is in Excel.
"Adding one line before the Call" is the fix. Thanks all who tried to help!

Application.Run "Solver.xla!Auto_Open"
Call RunSolver("Simple")