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

Look at the GetObject information. e.g,

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


"Sherry" wrote in message
...
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

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

--

HTH

RP

"Bill" wrote in message
...
Look at the GetObject information. e.g,

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


"Sherry" wrote in message
...
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