Automate

 View Only

  • 1.  Use macros to simulate a script

    Posted 07-31-2019 07:56
    Dear Everyone,

    A little help needed here, does someone knows if we can run the simulation mode of a Transaction script using a Macro in Excel?
    We're doing it for the real mode already, but would be interested to do it the same way for the simulation mode

    Many thanks for your help,

    ------------------------------
    Eve-Marine Loigerot | Assistant chief accountant
    Engie GBS |
    ------------------------------


  • 2.  RE: Use macros to simulate a script

    Posted 08-01-2019 03:22
    Hi Eve-Marine,

    I think you can from Version 11 onwards (Edit: You can in 10.7 see post below).  I'm running 10.7.1 and the Macro includes comments about possible run types, but does NOT include validate mode.  The version 11 documentation on the other hand does.  So addinobject.runtype = 7 would validate whatever rows you are running the script for.  I currently use a small VBA for which I present to the user which asks start and end row to process and a check box for 'run on error rows only.  You could easily add another check box to something like that for validate.

    Documentation is here: http://winshuttle-help.s3.amazonaws.com/studio/en/connect-sap/help/11/use-macros-to-run-script.htm

    See below:

    RunType

    0 – Run Specified Range

    1 - Run And Stop On Errors

    2 – Run First Five Rows

    3 – Run Only Error Rows

    4 – Run Only Unprocessed Rows

    5 – Debug Specified Range

    6 – Debug First Row Only

    7 – Validate Specified Range

    8 – Validate First Five Rows

    9 – Validate Only Error Rows

    10 – Validate Only Unprocessed Rows
    ​

    ------------------------------
    Mark Tiller | Delivery Enhancement Developer
    Transport for London (TfL) | 0203 054 4196
    ------------------------------

    Original Message


  • 3.  RE: Use macros to simulate a script

    Posted 08-01-2019 03:52
    Hi​ Eve-Marine,

    I found my copy of the version 10.7 documentation.  To validate in 10.7, it's addinobject.validate as opposed to addinobject.run

    ------------------------------
    Mark Tiller | Delivery Enhancement Developer
    Transport for London (TfL) | 0203 054 4196
    ------------------------------

    Original Message


  • 4.  RE: Use macros to simulate a script

    Posted 08-01-2019 04:00
    Hi Mark,

    We're using WinShuttle 12.1. I tried to change the Run Mode value in VBA and it works perfectly that way ! I can confirm we will use Run Mode 7 from now on.
    Many thanks for your time and your precious help !


    ------------------------------
    Eve-Marine Loigerot | Assistant chief accountant
    Global Energy Management | 0472361825
    ------------------------------

    Original Message


  • 5.  RE: Use macros to simulate a script

    Posted 08-01-2019 04:02
    ​Hi Eve-Marine,

    You are welcome, glad to be able to help.

    ------------------------------
    Mark Tiller | Delivery Enhancement Developer
    Transport for London (TfL) | 0203 054 4196
    ------------------------------

    Original Message