Launch non-office applications through VBA
 

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.

Launch non-office applications through VBA
 

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.

Launch non-office applications through VBA
 

Workbooks.Open Filename:="http://www.microsoft.com/"
Workbooks.Open Filename:="C:\My Documents\Excel\MyFile.xls"

--
Best wishes,

Jim


"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.

Launch non-office applications through VBA
 

Thanks.

"Jim Jackson" wrote:

Workbooks.Open Filename:="http://www.microsoft.com/"
Workbooks.Open Filename:="C:\My Documents\Excel\MyFile.xls"

--
Best wishes,

Jim


"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.

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.