View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
The Code Cage Team[_90_] The Code Cage Team[_90_] is offline
external usenet poster
 
Posts: 1
Default Universal VBA code for opening MS (Office ) programs from excel


You have to use the Shell command, this is directly from the excel
help:
This example uses the Shell function to run an application specified by
the user. On the MacIntosh, the default drive name is "HD" and portions
of the pathname are separated by colons instead of backslashes.
Similarly, you would specify Macintosh folders instead of \Windows.

' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator.


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=25385