Automator Excel to pdf

[Tracy McAnally]

I am new using automator and have zero experience with scripts. That said, each day I have 30+ excel files that I need to convert to pdf. I have a workflow that is working with Excel 2011 (not 2016 for some reason); however, several of the excel workbooks that are sent into me have somehow lost the original "print area" and thus when I save to pdf, it is spread on multiple pages. When I convert it manually, I just choose to print to pdf and check the box 1page wide by 1 page long and it works. My question is Can I somehow add that step in my workflow? Other info.--the name of the pdf must stay exactly the same as the original excel file. I hope this all makes sense. Any help will be appreciated.

 

[Cory Cooper]

Hello and welcome.

Most of us here aren't very well versed in AppleScript and Automator. This group of folks is:

MacScripter

Give them a try and see if they can help you out.

C