error while saving excel as PDF through vBA

[anunav]

Hello ,

I tried to use the code in thread223-416162 to save an excel spreadsheet to PDF.But IT gives me an error

Compile error:User-defined type not defined. and it highlights the "dim mypdff as pdfdistiller" line .

I have acrobat 8.1.0 and excel 2000.

I checked the references and I have selected all the acrobat related references.

Distiller object wont even show up in the objects (when you do -> dim mypdf as ).

Can you please help me .. I will be very thankful

AnuNav