User Tools

Site Tools


transformations:excelcommand

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:excelcommand [2022/01/31 14:25] – Add in "File already exists table" craigttransformations:excelcommand [2023/01/25 20:06] – [Run VBA macro settings] Update "Run VBA" settings craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-This action performs a process on an Excel file.+This action performs a command on an Excel file.
   * List sheets/ranges   * List sheets/ranges
   * Run VBA macro   * Run VBA macro
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<sup>*</sup>|If the macro being run accepts arguments, the values to be passed in are listed here.  Arguments should be\\ listed in the order the macro is expecting them.| |Macro arguments<sup>*</sup>|If the macro being run accepts arguments, the values to be passed in are listed here.  Arguments should be\\ listed in the order the macro is expecting them.|
 +|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).|
  
 <sup>*</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column.\\ <sup>*</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column.\\
transformations/excelcommand.txt · Last modified: 2023/04/20 19:36 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki