Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Solver and VBA in the same model

I have written a VBA application for solving a system of linear
equations. I tried to provide and alternative solution by setting up a
"Solver" problem in the same workbook. Solver runs OK and produces a
solution, however, when I try to run it again it simply does not appear.
Nothing. I have tried the input data in a new workbook with no VBA attached
and the solver will run repeatedly. However, if I copy the VBA code in, it
runs only once and I have to close the file and reopen to run a second time.
Any ideas on what may be happening, I can't find anything on the internet
which suggests a conflict between solver and VBA?

Thanks

Brian



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver model loading problem marineCORVETTEran Excel Discussion (Misc queries) 0 July 17th 08 11:31 PM
linear model with solver vert Excel Discussion (Misc queries) 1 April 4th 06 04:34 PM
Solver. When a model is liner and when it's not? PV Excel Discussion (Misc queries) 1 February 15th 06 04:16 PM
how do i model discounts in excel solver Samir Syed Excel Worksheet Functions 0 December 23rd 05 05:23 PM
Trouble getting solver to load a model Don C[_3_] Excel Programming 4 December 11th 03 02:16 PM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"