Homepage | About EASA | Contact
Guide Section: Processing Events and Performing Actions | EASAP Tree: EVENT PROCESSING Branch
EXPORT TO PDF creates a PDF representation of a certain part of a spreadsheet.
When an EXPORT TO PDF ACTION is triggered, an image of the current state of the specified Excel range is saved as a PDF in the EASAP folder for that run.
Optionally, set Open in Browser:→TRUE to open the PDF automatically in a new browser window.
The EASA object EXPORT TO PDF is implemented via Excel and Windows and as a result, has a few limitations outlined below.
EXPORT TO PDF reopens an Excel spreadsheet; this may be time-consuming if the spreadsheet is large.
To speed up this process EXPORT TO PDF will:
There are two cases where this higher-performing temporary spreadsheet will not be generated:
Either 'disable events' as the first line of macro code, below:
If Application.EnableEvents = False Then Exit Sub
Or 'wrap' the macro code within any triggered functions to disable processing
If not Application.EnableEvents = False Then // macro code End If
This disables event-triggered macro's during the time EXPORT TO PDF is making its copy of the relevant parts of the spreadsheet.
![]() |
|
---|---|
Essential Parameters: | |
Spreadsheet: | The SPREADSHEET that points to the actual spreadsheet. |
Output File Name: | Name of the file to be created should end in → .pdf |
Optional Parameters: | |
Open In Browser: | If 'TRUE', it opens the PDF document in a web browser window when it is created, otherwise its 'FALSE'. |
Type: | Specify the scope of the source in the spreadsheet. ('SINGLE', 'MULTI RANGES', and 'MULTI SHEETS AND RANGES') |
Delimiter: | Character to delimit object references in Value: (default→%) |
Sheet: | Source sheet for Ranges: if Type is 'MULTI RANGES', select a sheet for use with Ranges: |
Sheets: | Source sheet for Ranges: if Type is 'MULTI SHEETS AND RANGES', then use a comma delimited list of the same length as the list in Ranges: |
Ranges: | A list of comma separated cell ranges to be pictured in the PDF, object references are allowed. |
Do if: | Logical expression, if 'FALSE' then action NOT performed, otherwise 'TRUE'. |
Scale: | Percent of the original size, creates a smaller or larger PDF. default→ 100 |
Notes:
Some limitations apply to EXPORT TO PDF when Type:→MULTISHEETS AND RANGES