Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default How do I create a macro that will activate the solver?

I am not making progress and there for I am asking you guys if you have som
solver macro written on your pc if you could send me the whole programing?

I would be very grateful for that
thanks
Hjalti

"Fredrik Wahlgren" wrote:


"Hjalti" wrote in message
...
I have tried to record this and been exploring the help in Visual Basic

but
nothing that I find is working.. The macro debugger always stops at the
solver line reports this message " Compile error: Sub or function not
defined"

Best regards
Hjalti
from Iceland


Is this what you want?

Sub Makro1()
AddIns("Solver").Installed = True
End Sub

In my version of Excel, the solver is called "Problemlösaren".
/Fredrik



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
how to activate macro from cell artzuka Excel Discussion (Misc queries) 2 January 6th 09 09:12 PM
activate macro Jase Excel Discussion (Misc queries) 1 June 9th 08 08:25 PM
activate a cell value through a macro TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 November 10th 05 08:48 AM
how to create constaints in solver Supertins Excel Worksheet Functions 1 September 18th 05 10:46 PM
Run Macro on Worksheet Activate Matthew John Antoszkiw Excel Programming 2 February 23rd 04 12:01 PM


All times are GMT +1. The time now is 07:45 AM.

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

About Us

"It's about Microsoft Excel"