Results 1 to 2 of 2

Thread: Automation in excel
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Automation in excel

    Hi All,

    I'm a basic excel user and dont know how to automate my requirement using excel. I know excel is powerful and as i dont have programming background i'm not able to understand the vba. Can someone help me here.

    My requirement is I have few questions where I get answers from users.

    For eg:

    What is the name of your application - App1
    Service provided by this application - Financial service
    Any Modules - 2
    Module name - mod1, mod2
    Enabled capabilities? - 2
    Capability Names - Cap1, Cap2
    How many environments? 3
    Environments - Prod, Test, Acc
    managed by - ABC company
    owner - XYZ
    owning business - abc

    Based on the above input (requirements)

    1 The excel should provide me the naming standards like below

    Application Name - App1
    Service Name - Financial Service
    Offerings - App1_Cap1 and App1_Cap2
    Instances - App1_Prod, App1_Test, App1_Acc
    managed by - ABC company
    owner - XYZ
    owning business - abc
    Server Name - Ser1
    Router Name- R1

    2. Relationships data

    App1 consumes App1_Prod
    App1 consumes App1_Test
    App1 consumes App1_Acc
    Financial Service contains App1_Cap1
    Financial Service contains App1_Cap2
    App1_Cap1 depends on App1_Prod
    App1_Cap2 depends on App1_Prod
    App1_Prod depends on Ser1
    Ser1 depends on R1

    3. Populate this data to Visio


    Not sure how to attache pic here.

  2. #2
    New Member
    Join Date
    Sep 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Automation in excel

    Can anyone please help me on this?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •