I have a Numbers document that has many sheets and I regularly need to convert a single sheet to PDF and email it. So I thought I would automate this process. To do this manually I open the print dialog, and configure to print just the sheet and then change the drop down menu to save as PDF.
To date I have had zero success trying to do this using AppleScript. What I have found on sites like maxosxautomation.com seem to be result in the entire document being exported to PDF.
While I wait for my forehead to heal from pounding it against my desk, has anyone done this?