Converting Excel to PDF through VBA

[Access9001]

Is there code out there that doesn't require Adobe or PDFCreator? I can't buy/install Adobe and PDFCreator is the most aggravating, buggiest thing I've ever tried to use. Leban's code seems to work well for Reports->PDFs, but I need something that does Excel->PDFs. I've scoured the web with little success. Anyone have any advice on the matter?

Thanks!

 

[ghudson]

I use PDF995 at home. The FAQs state you can automate it to create PDFs. I have never tried to automate using PDF995 but it sounds like it will do what you want.