Hi all
One of the macro in my sheet uses an extra reference (PDFCreator, to create
PDF documents from the sheet).
My problem is the following: on a computer where this extra reference
(PDFCreator) is not installed, I cannot execute any of the macro of my sheet
(even those that doesn't use PDFCreator).

How can I do to:
- detect if the extra references needed are installed on the current
computer
- disable the functions using these references
- make the other functions work as usual

Thank you!

Dear Zorro,

Take a look at the "Visual Basic Add-In Model" entry at the Visual Basic
Language Reference. There you will find the documentation for the references
collection of objects, which will help you to accomplish your three tasks:

"Use the References collection to add or remove references. The References
collection is the same as the set of references selected in the References
dialog box."

Best,

RGO


"Zorro" wrote:

Hi all
One of the macro in my sheet uses an extra reference (PDFCreator, to create
PDF documents from the sheet).
My problem is the following: on a computer where this extra reference
(PDFCreator) is not installed, I cannot execute any of the macro of my sheet
(even those that doesn't use PDFCreator).

How can I do to:
- detect if the extra references needed are installed on the current
computer
- disable the functions using these references
- make the other functions work as usual

Thank you!