Prev: Converting a number (17 characters) to text (Scientific Notation)
Next: input box prompt
From: helene and gabor on 20 Apr 2010 14:14
Hello,

I have Excel 2007.
My Solver works OK.
My Solver would not work in VBA mode. All statements that start with Solver
are regarded as errors.
Peltier advises that Tools/Reference list Solver item should be given a
check mark.
However no such item as Solver exists on the Reference list.

Best Regards, and thanks

Gabor Sebo

From: michdenis on 20 Apr 2010 17:02
Hi,

| Peltier advises that Tools/Reference list Solver item should be given a
| check mark. However no such item as Solver exists on the Reference list.

if it's not on your list, use the browsing button on this Reference list
window until you find the file located here :
C:\Program Files (x86)\Microsoft Office\Office12\Library\SOLVER\SOLVER.XLAM


From: helene and gabor on 20 Apr 2010 17:50
Thanks for your assistance. Browse however shows nothing for: Solver.
Nothing.

Gabor





"michdenis" <michdenis(a)hotmail.com> wrote in message
news:310D01F6-13FE-4E07-B746-E220313458F1(a)microsoft.com...
> Hi,
>
> | Peltier advises that Tools/Reference list Solver item should be given a
> | check mark. However no such item as Solver exists on the Reference list.
>
> if it's not on your list, use the browsing button on this Reference list
> window until you find the file located here :
> C:\Program Files (x86)\Microsoft
> Office\Office12\Library\SOLVER\SOLVER.XLAM
>
>
>

From: Dana DeLouis on 20 Apr 2010 18:17
Just a guess.
Perhaps Solver was not installed.

In Windows(07), go to Control Panel - Programs and Features.
Microsoft Office - and select "Change"

Under Excel, make sure you have added Solver.


= = = = = =
HTH :>)
Dana DeLouis

On 4/20/10 5:50 PM, helene and gabor wrote:
> Thanks for your assistance. Browse however shows nothing for: Solver.
> Nothing.
>
> Gabor
>
>
>
>
>
> "michdenis" <michdenis(a)hotmail.com> wrote in message
> news:310D01F6-13FE-4E07-B746-E220313458F1(a)microsoft.com...
>> Hi,
>>
>> | Peltier advises that Tools/Reference list Solver item should be given a
>> | check mark. However no such item as Solver exists on the Reference
>> list.
>>
>> if it's not on your list, use the browsing button on this Reference list
>> window until you find the file located here :
>> C:\Program Files (x86)\Microsoft
>> Office\Office12\Library\SOLVER\SOLVER.XLAM
>>
>>
>>
>
From: helene and gabor on 20 Apr 2010 18:26
Hello,

Following your file reference I do have Solver on the list. The compiler
however still rejects the words: Solver.
I hope to find the reason.

Thank you very much!

Gabor

"helene and gabor" <gabelene(a)townisp.com> wrote in message
news:319252E2-1B03-497E-AE65-8548B6866FF4(a)microsoft.com...

 |  Next  |  Last
Pages: 1 2
Prev: Converting a number (17 characters) to text (Scientific Notation)
Next: input box prompt