If you have to do Office-automation in larger corporations, there'll probably be more than one Office-version. As a consequence, you won't be able to use early binding in order to support all (compatible) Office-versions being used. Hence, you'll neither be able to use the constants provided by the respective application. The work-around is to provide these constants yourself.
This demo contains modules for the most commonly targetted Office-applications.
This is one of the older entries that can also be found on the original Access-site.
Download: OfficeConstants.zip (288.52 kb)
Location: SinglePost