Properties of a document, help!
 

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

Properties of a document, 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

Properties of a document, 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