Launch non-office applications through VBA

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Thanks.

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

 

[Guest]

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.