Solved: Opening a doc

[bopo]

HI

I have this code beind a commandbutton:


Documents.Open FileName:="C:\sh.doc"


However a error message keeps occuring say object not found, I have tried mutiple locations (placing the doc in different locations and changing the code)

?

[Norie]

Is this in Word or Excel?

Because you've posted in the Excel section.:)

[bopo]

Excel, I want to open a word document using vba with my userform within excel

[CBrine]

bopo,
Requires a little more work from Excel.



Sub OpenWord()
Dim newApp As Object
Set newApp = GetObject("C:\test.doc")
newApp.Application.Visible = True
End Sub


HTH
Cal

[mdmackillop]

or
Sub OpenWord()
ActiveWorkbook.FollowHyperlink "C:\test.doc"
End Sub