Please Help! Quick Excel Issue

[kevinonexcel]

I have code that I am using to try to convert excel sheets to PDFs by using a macro

This line of code:

Dim myPDFCreator As PDFCreator.clsPDFCreator

Does not work. I am getting an error message that says compile error, user defined type not defined.

I installed PDFcreator but I am still getting this error.

What am I doing wrong?

 

[Andrew Poulsom]

You need to set a reference. Click your workbook in the Project window, choose Tools|References from the menu, locate and check PDFCreator then click OK. If you need more help look here:

http://www.excelguru.ca/node/89