Solved: Opening a doc

[bopo]

HI

I have this code beind a commandbutton:

[vba]
Documents.Open FileName:="C:\sh.doc"
[/vba]

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.

[VBA]

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

HTH
Cal

[mdmackillop]

or
[VBA]Sub OpenWord()
ActiveWorkbook.FollowHyperlink "C:\test.doc"
End Sub
[/VBA]