getting run time error 1004: method activeprinterof object application failed.

Hi friends,
I want to save a workbook in PDF format using ‘doPDF v7’
I’m getting run time error 1004: method activeprinterof object application failed.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you,

Did you record a macro to get the printer name? (which may not work with PDF, since you can just use

Please Login or Register  to view this content.

Yes, I tried to record a macro to get printer name but in vain.
I opened a workbook. Click on record macro. Give print command. Select doPdf v7 as printer but in recorded macro I didn't get a printer name.

Please suggest me a proper way to get a printer name by recording macro.

The code suggested by you is not working because there is no pdf option in save as file format.

Thank you.

You need an add-in:

http://www.microsoft.com/en-us/downl...s.aspx?id=9943