Excel Recorder

• If below error appears during test run,
  
  
  Go to Info and click Allow the information to be saved in your file link.

• User records the step in which content of one complete excel sheet is copied (Ctrl+A+A + Ctrl+C) to another excel sheet or workbook (Ctrl+V). This selection may fail during the test run and displays the System.Exception: ScriptStoreException: Out of memory error in the Automation Studio log file.
  
  

• User records the step in which content of one complete excel sheet is copied (Ctrl+A + Ctrl+C) to another application (Ctrl+V). The following highlighted macro line is shown in the generated script and System.Exception: ScriptStoreException: Out of memory error is shown in the log file.
  
  
  
  To fix the error:

  • Create a new unique input variable. For example, “excelRangeArg”.

  • Set the default value of the argument with threshold level value of row and column that you want to select. For example, “A1:AA10000”.

  • Replace the Cells.Select macro line with the Range(Parameters.Item("excelRangeArg ")).Select  macro line.