Question: Export (or Print) a Worksheet (ideally to PDF) under Program Control

I can export a worksheet (to many different formats), but the normal way of doing this requires a human in the loop and several mouse operations.

Is there a way to automate this?

I have on the order of 100 different worksheets and would like to capture them in an archival format (e.g., PDF).

Please Wait...