AppleScript: How do I save multiple Excel sheets to one pdf using Applescript

[sbtaylor1]

I have a Excel workbook with 6 worksheets. I want to save four of these worksheets as a single pdf document.

If I was doing this manually, I would set the print area for each worksheet. Then I would select the first worksheet and then <shift> select the other worksheets such that all four worksheets were selected. Then print the workbook to pdf.

I would like to automate this simple process in Applescript. I have set up Applescript to set the print area for each sheet. I can't seem to find the correct AppleScript to select the four worksheets and save them as one pdf document.

Can anyone help?

Thanks in advance.
Stuart.