VBA Code to convert Excel to PDF

[wayne]

I'm very new to Excel Programing. Anybody can tell me how to write VBA
codes to covert an Excel worksheet to a PDF file? Or is there any tool
I can use?

 

[Paul M]

Hi Wayne,

Do you have a PDF Generator (of sorts). You will firstly
need the device to be able to send the document to for
conversion.

You will either need to by Adobe Acrobat, or try the
shareware versions such as Neevia. Adobe 4, allows you to
utilse the procedures that install with the XLA, where
later versions are locked down.

My suggestion is to try Neevia, see if the output quality
is good enough for your requirements and take it from
there.

Good luck in your PDF quest.

P.

 

[Danny]

The easiest way I can think of doing this is installing a
piece of software which will act as a printer to produce
PDF's. For example Adobe Acrobat when installed adds Adobe
Acrobat Distiller to the list of printers installed on the
PC. What this does is anything that is sent to this
printer will be converted to a PDF and then you are
prompted for a save location.

You could fairly easily then write some code and which
simply selects Adbobe Acrobat as the printer and then
sends a print to it just the same as you would do
manually. Then all you will need to do is specify where to
save it to.

I know this solution is not the code itself but it is an
easy route should you choose to take it then post to the
forum asking for this code and you will easily find it.

Let me know if this helps or not.

Danny.

 

[Tom Ogilvy]

http://www.planetpdf.com

might be a place to look at.