openning word

[anthony]

Hi,

Is there any way to open a word file from excel?

 

[Foss]

Hi there,

How about this:

Sub OpenWord()
Shell "winword.exe", vbMaximizedFocus
End Sub

Cheers,
Foss

 

[AA2e72E]

Set objWd= CreateObject("Word.Application"
objWd.Open "fully qualified file name"
objWd.Visible = tru
set objWd = Nothin

Starts Word, opens a document and leaves it in the task bar for the use to use/close.

 

[anthony]

This works very well to open word, but is there any way
to open a specific word file, i just keep getting a
runtime 5 error.

 

[Foss]

How about this one?

Sub OpenWord()
Shell "winword.exe " & Chr(34) & "C:\address.doc" & Chr
(34), vbMaximizedFocus
End Sub

This works for me..

Cheers,
Foss

 

[anthony]

Works Perfectly, Thanks Foss.

-----Original Message-----
How about this one?

Sub OpenWord()
Shell "winword.exe " & Chr(34) & "C:\address.doc" & Chr
(34), vbMaximizedFocus
End Sub

This works for me..

Cheers,
Foss

.

 

[Foss]

Glad to hear it

----- anthony wrote: ----

Works Perfectly, Thanks Foss