Properties of a document, help!

J

Jason

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
 
B

Bob Phillips

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
(Tools>References)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

Jason

cheers bob

Bob Phillips said:
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
(Tools>References)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Top