Print to PDF - Adobe Writer

**hassankhan** · 12-15-2009, 07:04 AM

Right now if I want to save an excel as pdf, I hit print and select - pdf.

Please Login or Register  to view this content.

That obviously works without fail, once that is clicked a prompt box opens to confirm name and target directory of the file.

I would like to automate this function. Currently to auto save the excel as an excel I am using the following code.

Please Login or Register  to view this content.

So ultimately, when the macro is appiled.
A PDF will automaticaly be created as value n5 in the the path of the active workbook.

**Domski** · 12-15-2009, 07:15 AM

You might want to have a look at the code I posted here:

http://www.mrexcel.com/forum/showthr...=193347&page=2

Dom

**DonkeyOte** · 12-15-2009, 07:29 AM

see also: http://www.excelguru.ca/node/21

**hassankhan** · 12-15-2009, 07:41 AM

Originally Posted by DonkeyOte

see also: http://www.excelguru.ca/node/21

Had a look at both codes, would it run with adobe writer standard 6.0

**Domski** · 12-15-2009, 07:49 AM

I'm afraid I don't think so. To my knowledge you need the professional versions of Adobe to be able to fully control Adobe with code.

The link that DonkeyOte has details of another pdf creator that you can download to use that code with and I've also seen code that people have automated CutePdf with but never tried it myself.

Dom