Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Needing help with code in a macro

Does anyone know the code to call up the calculator?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Needing help with code in a macro

Sub Macro1()
Application.ActivateMicrosoftApp Index:=0
End Sub

--
Gary''s Student - gsnu200781


"MWhaley" wrote:

Does anyone know the code to call up the calculator?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Needing help with code in a macro

That works great Gary Thanks a lot

"Gary''s Student" wrote:

Sub Macro1()
Application.ActivateMicrosoftApp Index:=0
End Sub

--
Gary''s Student - gsnu200781


"MWhaley" wrote:

Does anyone know the code to call up the calculator?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Needing help with code in a macro

You are very welcome! If you get tired of "calculating", use a -1 rather than
0 in the macro.
--
Gary''s Student - gsnu200781


"MWhaley" wrote:

That works great Gary Thanks a lot

"Gary''s Student" wrote:

Sub Macro1()
Application.ActivateMicrosoftApp Index:=0
End Sub

--
Gary''s Student - gsnu200781


"MWhaley" wrote:

Does anyone know the code to call up the calculator?

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Needing help with code in a macro

Is this some sort of "Easter Egg" program hidden away in Excel? If so, I'm
thinking it may have been removed with the latest Service Pack. I have Excel
2003 and when I execute that statement I get the following error...

Run-time error '1004':

Cannot run 'SOL.EXE'. The program or one of its
components is damaged or missing

Rick

"Gary''s Student" wrote in message
...
You are very welcome! If you get tired of "calculating", use a -1 rather
than
0 in the macro.
--
Gary''s Student - gsnu200781


"MWhaley" wrote:

That works great Gary Thanks a lot

"Gary''s Student" wrote:

Sub Macro1()
Application.ActivateMicrosoftApp Index:=0
End Sub

--
Gary''s Student - gsnu200781


"MWhaley" wrote:

Does anyone know the code to call up the calculator?




  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default Needing help with code in a macro

On my system it runs Solitaire located in:

C:\WINDOWS\system32\sol.exe

I am using WinXP
--
Gary''s Student - gsnu200781


"Rick Rothstein (MVP - VB)" wrote:

Is this some sort of "Easter Egg" program hidden away in Excel? If so, I'm
thinking it may have been removed with the latest Service Pack. I have Excel
2003 and when I execute that statement I get the following error...

Run-time error '1004':

Cannot run 'SOL.EXE'. The program or one of its
components is damaged or missing

Rick

"Gary''s Student" wrote in message
...
You are very welcome! If you get tired of "calculating", use a -1 rather
than
0 in the macro.
--
Gary''s Student - gsnu200781


"MWhaley" wrote:

That works great Gary Thanks a lot

"Gary''s Student" wrote:

Sub Macro1()
Application.ActivateMicrosoftApp Index:=0
End Sub

--
Gary''s Student - gsnu200781


"MWhaley" wrote:

Does anyone know the code to call up the calculator?



  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Needing help with code in a macro

That's a new one for me... interesting, though, it seems Index=0 is not
documented in the help files.

By the way, there is a shorter statement that will also bring up the
calculator (on PCs)...

Shell "Calc"

Rick


"Gary''s Student" wrote in message
...
Sub Macro1()
Application.ActivateMicrosoftApp Index:=0
End Sub

--
Gary''s Student - gsnu200781


"MWhaley" wrote:

Does anyone know the code to call up the calculator?


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
Needing Help Khanjohn Excel Programming 3 April 21st 07 01:45 PM
Can I use code/macro to change code/macro in an existing file? Scott Bedows Excel Programming 2 February 14th 07 05:50 AM
Needing Help Very Bad Mike Excel Worksheet Functions 6 July 19th 06 07:23 AM
VBA newb needing help with an IF duster Excel Programming 4 June 27th 04 10:28 PM
VBA code needing alteration gavmer[_2_] Excel Programming 0 March 1st 04 12:48 AM


All times are GMT +1. The time now is 01:48 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"