Activating Word from within Excel using VBA

[Gesualdo]

I'm trying to open Word from an Excel VBA application, but I'm getting
"ClassFactory cannot supply requested class". The code I'm using is

Dim appWD As Word.Application

Set appWD = CreateObject("Word.Application")
appWD.Visible = True

I'm using Office 2003 Pro in Windows 2000, and have created a reference to
the Word 11.0 object library.

 

[Uday Takbhate [MSFT]]

You will not have to call CreateObject() if you have already created a
reference to the Word 11.0 object library from Excel VBA

Thanks
Uday Takbhate [MSFT]
Microsoft Developer Support
--------------------