Opening a Word Document from an Excel VBA Module

You need to set an object variable equal to the application, opening the application through createobject rather than activatemicrosoftapp. Set the application to visible if you need to see what’s going on, then you can use the object variable to access Word’s VBA to open the workbook:

Sub automateword()

Set wordapp = CreateObject("word.Application")

wordapp.documents.Open "C:\Documents and Settings\anitao\My Documents\alo2004.doc"

wordapp.Visible = True

End Sub

Article 307216 gives much more detail about using automation with Word

How to use Automation with Word 2002

http://support.microsoft.com/Default.aspx?kbid=307216

I hope this is helpful,
-brenda (ISV Buddy Team)

MSISVBuddyTeam at 2007-9-9 >

-brenda (ISV Buddy Team)

MSISVBuddyTeam at 2007-9-9 >