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.
|EXPORT TO PDF|
|Spreadsheet:||The SPREADSHEET that points to the actual spreadsheet.|
|Output File Name:||Name of the file to be created should end in → .pdf|
|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|
Some limitations apply to EXPORT TO PDF when Type:→MULTISHEETS AND RANGES