I get an
Automation Error
Class Factory cannot supply requested class

on the following line

Set appWord = CreateObject(Class:="word.application")

I can use VBA's Object Browser to open the Word class library and then find the Application class in the library. So what is automation looking for that is different than in the class library?

I am working with Office 2003 and have references to the Microsoft 11.0 libraries for Word, Access and Office. I also have references to the VBA, Ole Automation, and ADO 2.1 libraries.

I use this:

Dim appWord as Word.Application

Set appWord = CreateObject("Word.Application")


HTH...






Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com