Macro to open other applications

[Sherry]

Is it possible to run a macro within excel to open other
applications like word?

My macro keeps returning the following error: "File format
is not valid".

Thanks

 

[Bill]

Look at the GetObject information. e.g,

Set WDApp = GetObject(, "Word.Application")

 

[Bob Phillips]

You need more than GetObject, as the app may not be instantaited already.
Something like

On Error Resume Next
Set WDApp = GetObject(, "Word.Application")
If WDApp Is Nothing Then
Set WDApp = CreateObject("Word.Application")
If WDApp Is Nothing Then
Exit Sub
End If
End If

... do your stuff