hi, is there anyway that i could make a file open with microsoft word from
vba (excel), its a .out file, it could be opened by changing its properties
(open with) to word, but could it be done through coding?, please help

Something like

Dim oWordApp As Word.Application
Dim oWordDoc As Word.Document

Set oWordApp = New Word.Application
oWordApp.Visible = True
Set oWordDoc = oWordApp.Documents.Open(Filename:="filename")
'more code
Set oWordDoc = Nothing
oWordApp.Quit
Set oWordApp = Nothing

You will need to set a reference to the Microsoft Word library
(ToolsReferences)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jason" wrote in message
...
hi, is there anyway that i could make a file open with microsoft word from
vba (excel), its a .out file, it could be opened by changing its
properties
(open with) to word, but could it be done through coding?, please help

cheers bob

"Bob Phillips" wrote:

Something like

Dim oWordApp As Word.Application
Dim oWordDoc As Word.Document

Set oWordApp = New Word.Application
oWordApp.Visible = True
Set oWordDoc = oWordApp.Documents.Open(Filename:="filename")
'more code
Set oWordDoc = Nothing
oWordApp.Quit
Set oWordApp = Nothing

You will need to set a reference to the Microsoft Word library
(ToolsReferences)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jason" wrote in message
...
hi, is there anyway that i could make a file open with microsoft word from
vba (excel), its a .out file, it could be opened by changing its
properties
(open with) to word, but could it be done through coding?, please help