Windows Perl Scripting Forums » News

OLE: save .xls as .pdf?

(3 posts)

Tags:


  1. Anonymous

    Hi,
    Using a perl/OLE script, I'm trying to save an excel spreadsheet as a pdf file. Is there a way to use SaveAs to do this?

    Posted 5 years ago #
  2. Anonymous

    I've partially answered my own question. The proper syntax is

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

    this saves the first sheet of the workbook. My question now is how do I tell excel 2010 to save the entire workbook--all sheets?

    Thanks again!

    Posted 5 years ago #
  3. Anonymous

    If you're using Office v.X open the .xls file in Excel for X and go to File:Print. Click on the Preview button at the bottom of the print dialog box. It will Open in Preview.app. In Preview go to File:Save as PDF...

    Norton coupons

    Posted 4 years ago #

RSS feed for this topic

Reply

You must log in to post.