Getting the calculator


Posted by Mike Golding on January 22, 2002 1:58 PM

Some time ago I used a macro to show the Windows Calculator on top of a work sheet. With the passage of time and the overloading of the same brain it now totally eludes me. Can anybody please give me a jolt?
Thanks for the thought, Mike.

Posted by Joe Was on January 22, 2002 2:45 PM

If you put this in a code page Sub it should pull the calculator. If not do a windows search for the calculator path! JSW

Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1)

The "1" is a position upper left of the screen?
JSW



Posted by Mike Golding on January 22, 2002 8:02 PM

Sincerest thanks To Joe Was.It work a treat. From Mike Golding