Differences

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

--- transformations:excelcommand [2022/08/19 05:01] – [Description] dmitry
+++ transformations:excelcommand [2023/04/20 19:33] – [Action settings] Add reference to .xlsb and .xls files craigt
@@ Line 23: / Line 23: @@
 =====Action settings=====
 ^ Setting  ^ Description  ^
-|File<sup>*</sup>|Enter or browse to the fully qualified path and filename of the Excel file (.xlsx or .xlsm) to perform and command on.|
+|File<sup>*</sup>|Enter or browse to the fully qualified path and filename of the Excel file (.xlsx, .xlsm, .xlsb,
+ or .xls) to perform and command on.|
 |Command|Select the command to run on the selected Excel file.  Options:  //List sheets/ranges//, //Run VBA macro//, //Rename sheet//, //Delete sheet//, or //Recalculate workbook//.  See below for details of each command.|
@@ 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.|
 |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.\\