Re: Using Win32::OLE and Excel - Tips and Tricks

[Anonymous Monk]

Thanks for the informative post. I'd like to add that, for Excel, if you want to save your output in PDF format, you need to use "57" in a SaveAs call:

$Book->SaveAs($pdf_file_name,57);

This will save the first sheet as PDF. Does anyone know how to tell Excel to save the entire workbook as PDF?

TIA,

Bill

[Anonymous Monk]

Hi

New questions go in Seekers Of Perl Wisdom because

cacharbe, whom you asked a question, hasn't been here in 2 years.

the tutorial to which you replied is 9.5 years old.

Welcome, see The Perl Monks Guide to the Monastery, see How do I post a question effectively?, Where should I post X?