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.

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.

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.

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.

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.