How to use WIN32OLE to Save As PDF

Ruby
1

Hi,

I’ve been trying to figure out how to use Win32OLE to save as a PDF. It
doesn’t seem like there’s any good documentation on how to do this, so I
was hoping someone here has experience with this.

Anyhoo, if anyone’s tried this before, and actually gotten somewhere
with it, please let me know.

Thanks

2

On Jan 22, 2:08 pm, Joe P. [email protected] wrote:

–
Posted viahttp://www.ruby-forum.com/.

Ever look at this?

http://ruby-pdf.rubyforge.org/pdf-writer/

Seems like it’d be straightforward, at least moreso than digging into
all of the OLE stuff…

3

Greg Kujawa wrote:

Ever look at this?

http://ruby-pdf.rubyforge.org/pdf-writer/

Seems like it’d be straightforward, at least moreso than digging into
all of the OLE stuff…

Yeah, I’ve seen that. I just figure there has to be a way to save
directly as a PDF using WIN32OLE. If only there was like a list of
FileFormats that it uses…

4

On Fri, Jan 22, 2010 at 2:20 PM, gregarican [email protected]
wrote:

On Jan 22, 2:08 pm, Joe P. [email protected] wrote:

Ever look at this?

http://ruby-pdf.rubyforge.org/pdf-writer/

Please don’t use PDF::Writer anymore. If you need pure Ruby PDF
generation, Prawn is the way to go.
If there are features that are holding you back, let us know.

(Disclosure: I am the maintainer of Prawn and the ‘if all hell breaks
loose’ maintainer of PDF::Writer (originally written by Austin
Ziegler) )

-greg

5

On 22.01.2010 20:27, Joe P. wrote:

Yeah, I’ve seen that. I just figure there has to be a way to save
directly as a PDF using WIN32OLE.

Only if an OLE capable tool is installed that a) accepts your input and
b) writes PDF (for example, OO.o Writer, or MS Word 2007).

6

Alrighty, so I figured it out.

It turns out 17 is the FormatType for PDF, so you just have to do
something like this:

document.SaveAs(filename, 17)

I didn’t see any documentation about this, but we just started going up
from 0 as a FormateType, and once we hit 17, it made a valid PDF!!

7

On Fri, Jan 22, 2010 at 3:05 PM, Joe P. [email protected]
wrote:

Alrighty, so I figured it out.

It turns out 17 is the FormatType for PDF, so you just have to do
something like this:

document.SaveAs(filename, 17)

FormatType for what? You never mentioned what program you’re using
via win32ole (i’m assuming MS Office?). In the future, be sure to do
that so that people know what you’re talking about.

-greg

8

FormatType for what? You never mentioned what program you’re using
via win32ole (i’m assuming MS Office?). In the future, be sure to do
that so that people know what you’re talking about.

-greg

Sorry. Yeah, I’m using MS Office through win32ole.

9

In case anyone else is searching for how to use win32ole to save as a
PDF, Mr. Mullet posted some nice instructions here:

10

Joe P. wrote:

In case anyone else is searching for how to use win32ole to save as a
PDF, Mr. Mullet posted some nice instructions here:
Ruby on Windows: Saving Microsoft Office Documents as PDFs

To can save office 2007 documents to pdf format you have to download the
free ms plugin, google => ‘pdf plugin office 2007’

11

Gregory B. wrote:

On Fri, Jan 22, 2010 at 2:20 PM, gregarican [email protected]
wrote:

On Jan 22, 2:08�pm, Joe P. [email protected] wrote:
Ever look at this?

http://ruby-pdf.rubyforge.org/pdf-writer/
Please don’t use PDF::Writer anymore. If you need pure Ruby PDF
generation, Prawn is the way to go.
If there are features that are holding you back, let us know.

(Disclosure: I am the maintainer of Prawn and the ‘if all hell breaks
loose’ maintainer of PDF::Writer (originally written by Austin
Ziegler) )

What Greg said.

-austin

12

On 26.01.2010 23:12, Marco M. wrote:

To can save office 2007 documents to pdf format you have to download the
free ms plugin, google => ‘pdf plugin office 2007’

Better way: install Office 2007 Service Pack 2, which includes the
functionality.