transformations:excelcommand
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:excelcommand [2022/01/31 14:25] – Add in "File already exists table" craigt | transformations:excelcommand [2023/04/20 19:33] – [Action settings] Add reference to .xlsb and .xls files 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< |
+ | or .xls) to perform and command on.| | ||
|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 48: | ||
|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).| | ||
< | < |
transformations/excelcommand.txt · Last modified: 2023/04/20 19:36 by craigt