Open/Run Another Application/File Using VBA

[animas]

I need to open/launch
-applications like Outlook, IE
-files like .bat, .xls,
-folders (with windows explorer)

using VBA.

How to code this?

 

[wigi]

With a simple loop like there have been thousands on this website:

Sub OpenApplication()
    Dim r As Range
    For Each r in Range("B2:B100").SpecialCells(2,2)
         Shell r.Text, vbNormalFocus
    Next
End Sub

But why not add shortcuts to the programs in your Windows Startup folder? That could be personalized by PC and / or by user.

Wigi

 

[animas]

working nicely. thanks.