Automate

 View Only

  • 1.  Winshuttle Embedded Excel Data File Deck

    Posted 03-14-2019 15:31
    Hello everyone!
    Does anyone in our community have experience with building a multi-tab Excel workbook that holds several data files and templates where all you have to do is click a tab and you'll have the appropriate template with the correct script attached to run when you log into Winshuttle via Excel? 

    What I'm looking for is to bind the script to Excel (which I know how to do), but do this in the same workbook for each script with a tab per script which I can't seem to figure out.  I don't know how to word what I'm looking for exactly but I do know that it uses a Carryon sheet and the build generates a hidden tab that is named  _EmbeddedSHUTTLEfiles. 

    One thing to mention is that my scripts are built already and I do not know if this will also be a problem trying to build what I am looking for.

    TIA!

    ------------------------------
    Dee Tabin | Sr. Business Planning Analyst
    The Walt Disney Company | 321-939-7825
    ------------------------------


  • 2.  RE: Winshuttle Embedded Excel Data File Deck

    Posted 03-15-2019 05:02
    Hi Dee,
    We use a number of those templates.
    Typically on one sheet we enter data, from this sheet a number of other sheets are filled using VBA-scripts.​ To each of these sheets a Winshuttle script for SAP-upload is linked, all of these Winshuttle scripts are chained. Building the chain in Winshuttle, make sure to use custom settings: all of the scripts must refer to their specific sheet, but the SAP-logon should be used from the first script in the chain (see image). When launching the first Winshuttle script on its correct sheet, the other scripts will follow, activating the correct sheet and uploading the data.
    I think you will be able to use your already built scripts, just make sure they refer to the correct sheets in the file when saving.

    that's it, basically, I hope this can help you

    best regards, Jan​

    ------------------------------
    Jan Ketele | Sr engineer release management
    Xeikon Manufacturing NV | +3234431875
    ------------------------------

    Original Message


  • 3.  RE: Winshuttle Embedded Excel Data File Deck

    Posted 03-15-2019 07:00

    Hi Jan,
    Thank you so much for that info! 

    One question to clarify - when you run the script the one tab it's just running the one script, not every one of them because it's linked? I do have scripts that work like that - where I want one data file to run multiple scripts back to back for a single tab because I have chained them and that is their intended purpose. 

    In this instance, I just want an Excel tab with a template that can be filled in with the data we want to update in SAP, click on Run and it runs Winshuttle via Excel for only the single script embedded for the specific tab.  Will the process you mentioned do that?  I just want to be sure I totally understand which way does what.

    Thanks so much!
    Dee



    ------------------------------
    Dee Tabin | Sr. Business Planning Analyst
    The Walt Disney Company | 321-939-7825
    ------------------------------

    Original Message


  • 4.  RE: Winshuttle Embedded Excel Data File Deck

    Posted 03-15-2019 07:21
    Hi Dee,

    The way we use these templates: start from the first tab we want a (chained) script to upload from. When the 1st script of the chain is done uploading​ the 2nd script from the chain takes command: 2nd tab opens and 2nd script starts uploading. When done the 3rd takes the lead opening 3rd tab etc ... And if I understood correctly that's exactly what you were looking for.
    You could, obviously, also have all the scripts work from a single tab within this excel, I prefer the seperate tabs just for clarity.

    enjoy scripting, Jan

    ------------------------------
    Jan Ketele | Sr engineer release management
    Xeikon Manufacturing NV | +3234431875
    ------------------------------

    Original Message


  • 5.  RE: Winshuttle Embedded Excel Data File Deck

    Posted 03-15-2019 07:25

    That's exactly what I was looking for.  Thank you so much for clarifying, I appreciate your time! :)

    Thanks for being so helpful! Have a wonderful day!

    Dee



    ------------------------------
    Dee Tabin | Sr. Business Planning Analyst
    The Walt Disney Company | 321-939-7825
    ------------------------------

    Original Message


  • 6.  RE: Winshuttle Embedded Excel Data File Deck

    Employee
    Posted 03-15-2019 09:27
    Hi Dee

    You can LOCK the script to a specific sheet when you publish it.   You can do this with the LOCK icon on the ribbon in Studio or choose the option when you publish it.
     
    Then when you swap sheets in a workbook, the correct script will default, and it will only run on the sheet you locked it to.

    You can run then one script, or chain them, as Jan is doing.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle North America
    ------------------------------

    Original Message


  • 7.  RE: Winshuttle Embedded Excel Data File Deck

    Posted 03-15-2019 09:43
    Many thanks, Sigrid, this will improve these scripts.
    Upto now, I had to make sure to save them with the correct sheet opened to make it work. ​

    enjoy the weekend
    Jan

    ------------------------------
    Jan Ketele | Sr engineer release management
    Xeikon Manufacturing NV | +3234431875
    ------------------------------

    Original Message


  • 8.  RE: Winshuttle Embedded Excel Data File Deck

    Employee
    Posted 03-15-2019 09:50
    My pleasure, Jan!  I have faced the same issue and had to learn the hard way. 

    Please be sure to set the sheet lock for each script and save them again.  Then chain them together.  That way the chain will respect the sheet on which to run the script.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle North America
    ------------------------------

    Original Message