Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Class does not support Automation

Status
Not open for further replies.

bronc

Instructor
Aug 28, 2003
145
GB
Hello
I am using this code from Excel.

Option Explicit

Dim appWord As Word.Application

Sub AddData()
Set appWord = New Word.Application
End Sub

and I get this message.

"Class does not support Automation or does not support expected interface"

I have tried the exact same code on other machines with identical references set in Word VBA and Excel VBA and it works fine.

Thanks

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top