Problem after removing PDFCreator

[Neil Ives]

Hi,

I'm working an an Excel project that uses the Third party PDFCreator to send out PDF sheets. Not all my users have PDFCreator installed. The missing reference to PDFCreator, (in the master file) causes problems that I do not want my users to have to 'lift the hood' over.

I have added Ken's Puls's code as the first line of my Workbook Open module to remove missing library references in my project and tested it by uninstalled my copy of PDFCreator while leaving the Reference to PDFCreator in the VBA list.

Now my project is falling over on simple VBA key functions such as DateValue(Date) and the Reference was not removed.

Can anyone offer me a suggestion of the best way to deal with this?

Many thanks.

Neil Ives

[Kenneth Hobs]

Have you tried removing it from the add-ins?

[Bob Phillips]

Have you tried late-binding it (remove the reference) and testing for a valid object?