How to use WIN32OLE to Save As PDF

[Joe Peck]

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

 

[gregarican]

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

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...

 

[Joe Peck]

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....

 

[Gregory Brown]

On Jan 22, 2:08=A0pm, Joe Peck <[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

 

[Phillip Gawlowski]

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, O Writer, or MS Word 2007).

 

[Joe Peck]

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!!

 

[Gregory Brown]

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

 

[Austin Ziegler]

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

 

[Joe Peck]

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.

 

[Joe Peck]

In case anyone else is searching for how to use win32ole to save as a
PDF, Mr. Mullet posted some nice instructions here:
http://rubyonwindows.blogspot.com/2010/01/saving-microsoft-office-documents-as.html

 

[Marco Mastrodonato]

In case anyone else is searching for how to use win32ole to save as a
PDF, Mr. Mullet posted some nice instructions here:
http://rubyonwindows.blogspot.com/2010/01/saving-microsoft-office-documents-as.html

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

 

[Phillip Gawlowski]

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.

http://support.microsoft.com/?scid=kb;en-us;953195&x=8&y=10