I have an excel spreadsheet with a command button on it. The logic behind the button creates a Word session and opens an existing document. When my client runs the spreadsheet he gets error #429:ActiveX Component cannot create object. The Code is below.
Private Sub CommandButton1_Click()
Dim oWordApp As Object
Set oWordApp = CreateObject("Word.Application")
Set oDoc = oWordApp.Documents.Open("cguides.doc")
oWordApp.Visible = True
End Sub
Has anyone had the same problem or know what is wrong?
Thanks
Jim
Thanks
Jim