Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements

Discussions

Members

Resources

Events

 View Only

  • 1.  Restricting script running to a particular tab in a workbook / template

    Posted 17 hours ago

    If I have a template excel file with many tabs in it. Is there a way that i can prevent a script from running on any other tab than the one it has been developed for . Example

    Tab 1 - Customer names

    Tab 2 - Products

    I have a script that runs MM02 to update product data. I only want it to be able to run against the Tab 2.. Better yet - If Tab 1 is active - would be to run the script and it knows that it needs to jump to tab 2 to process ?

    Thanks 



    ------------------------------
    Russel Hunter
    TTI EMEA Ltd
    ------------------------------


  • 2.  RE: Restricting script running to a particular tab in a workbook / template

    Posted 16 hours ago

    Well I answered my own question - On the RUN menu item - top left - where it specifies Sheet - Start Row - End Row.

    There is a little padlock symbol. It seems one can "lock" it to what you specify in your script. Excellent feature. 



    ------------------------------
    Russel Hunter
    TTI EMEA Ltd
    ------------------------------



  • 3.  RE: Restricting script running to a particular tab in a workbook / template

    Employee
    Posted 15 hours ago

    Hi Russel,

    Yes, the padlock icon in Automate Studio is used to lock specific run settings, including the Sheet, so that a runner cannot change them. This ensures that the script always uses the designated sheet.
    Thanks
    Jagat



    ------------------------------
    jagat kaushal
    *Precisely Software Inc.
    ------------------------------

    Original Message