THanks, but let us assume that even though I have the office 11 type
library available, I never want to use it. I only want to use the
office 10 type library, but it does not appear in the References list.
Is there anyway to do this?


Bob Phillips wrote:
Use late binding.

Instead of something like

Dim wdApp As Word.Application

Set wdApp = New Word.Application

you would use

Dim wdApp As Object

Set wdApp = CreateObject("Word.Application")

and you don't set a reference in VBE (which is where the problem arises).

but you don't have access to the application constants in this case

One technique is to develop with early binding, and change to late binding
to release. There is a walk-through example at
http://www.xldynamic.com/source/xld.EarlyLate.html