transformations:excelcommand
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| transformations:excelcommand [2022/01/31 13:07] – Add Re-save and Save to PDF modes. craigt | transformations:excelcommand [2023/04/20 19:36] (current) – [Action settings] craigt | ||
|---|---|---|---|
| Line 5: | Line 5: | ||
| \\ | \\ | ||
| =====Description===== | =====Description===== | ||
| - | This action performs a process | + | This action performs a command |
| * List sheets/ | * List sheets/ | ||
| * Run VBA macro | * Run VBA macro | ||
| Line 23: | Line 23: | ||
| =====Action settings===== | =====Action settings===== | ||
| ^ Setting | ^ Setting | ||
| - | |File< | + | |File< |
| |Command|Select the command to run on the selected Excel file. Options: | |Command|Select the command to run on the selected Excel file. Options: | ||
| Line 47: | Line 47: | ||
| |Capture return value|If the macro being run is a function that returns a value, checking this will capture the return value.| | |Capture return value|If the macro being run is a function that returns a value, checking this will capture the return value.| | ||
| |Macro arguments< | |Macro arguments< | ||
| + | |If macro fails|Select how EasyMorph behaves if the Excel macro fails to run. Options: //Fail// (display an error and stop the workflow) or //Warn// (display a warning and continue the workflow).| | ||
| < | < | ||
| Line 82: | Line 83: | ||
| ^Setting^ Description | ^Setting^ Description | ||
| |PDF file< | |PDF file< | ||
| - | |If the PDF file already exists|Choose how EasyMorph will handle situations when the PDF file already exists. Options: | + | |If the PDF file already exists|Refer to the // |
| |Page range|Choose which pages to include in the PDF file. Options: | |Page range|Choose which pages to include in the PDF file. Options: | ||
| |Sheets|Choose which workbook sheets will be exported to the PDF file. Options: | |Sheets|Choose which workbook sheets will be exported to the PDF file. Options: | ||
| Line 88: | Line 89: | ||
| < | < | ||
| + | \\ | ||
| + | ====File already exists options==== | ||
| + | ^Option ^Description ^ | ||
| + | |Overwrite|The new file replaces the original file.| | ||
| + | |Rename|The original file will be renamed with " | ||
| + | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
| \\ | \\ | ||
| =====Remarks===== | =====Remarks===== | ||
transformations/excelcommand.txt · Last modified: 2023/04/20 19:36 by craigt