View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Madhan Madhan is offline
external usenet poster
 
Posts: 78
Default Launch non-office applications through VBA

Thanks. This is exactly what I wanted. COM objects may not be available for
applications that are created by us, whereas shell would allow us to lauch
any application. Thanks once again.

"Nile_Hef" wrote:

The VBA command you want is the 'Shell' Function

Shell "Notepad.exe"

However, you should look for a any COM object which might expose the
application as an object variable with properties and methods you can call
directly from your code.

N

"Madhan" wrote:

Is it possible to launch non-office applications such as IE or Windows
explorer through VBA, which has a similar effect as, running these
applications from the RUN prompt giving arguments such as URL or windows path
respectively.