How to create a PDF document with VBA?


T

Tom

Hi

I'd like to create a pdf document with vba, but I don't own the adobe
acrobat writer (it's too expensive). Is it possible to do it with a third
party writer which costs at maximum $100? If yes, can you please provide an
example?

Tom
 
Ad

Advertisements

P

papou

Hello Tom
You could easily do this with CutePdf which is freeware.
http://www.cutepdf.com/
Also it would amount to a very basic vba routine since you would only have
to specify the CutePdf printer before launching a printout command!

HTH
Cordially
Pascal
 
C

Chip Pearson

I use PDF995, which sets itself up as a printer. To create a PDF
document, all you do is print to the PDF995 "printer".
http://www.pdf995.com/

For what its worth, the next version of Excel, due out at the end
of the year, will have PDF support built right in to Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

Tom

thx, that sounds great!


Chip Pearson said:
I use PDF995, which sets itself up as a printer. To create a PDF document,
all you do is print to the PDF995 "printer". http://www.pdf995.com/

For what its worth, the next version of Excel, due out at the end of the
year, will have PDF support built right in to Excel.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Ad

Advertisements

T

Tom

Chip

I downloaded the PDF995-writer and created the folowing macro:

Sub Print_PDF()
ActiveSheet.PrintOut _
ActivePrinter:="PDF995 on Ne03:", _
PrintToFile:=True, _
PrToFilename:="C:\Temp\Test.pdf"
End Sub

The pdf file was created but I'm not able to open it with the Adobe Acrobat
Reader. The error message 'unknown format' appears. Any ideas?

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top