SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jul 2010
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    How to get name of Activated Menu Bar in Excel

    Hi ,

    I want to retrieve open menu name in Excel using vbs .

    If anyone having code to activate menu bar do share.

    Thanks in advance

    Regards,
    ~ Nilesh

  2. #2
    Moderator
    Join Date
    Jul 2005
    Location
    Delhi
    Posts
    15,575
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)
    Total Downloaded
    0

    Re: How to get name of Activated Menu Bar in Excel

    Why do you want to do that?

  3. #3
    Junior Member
    Join Date
    Jul 2010
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to get name of Activated Menu Bar in Excel

    I want validate open menu tab in our test cases..



    Thanks,
    Nilesh

  4. #4
    Member
    Join Date
    May 2009
    Posts
    162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to get name of Activated Menu Bar in Excel

    Your requirement seems to be very specific. Can you answer the following

    1) Are you trying to validate excel based application / form ?
    2) Can you not use excel com object to automate your test cases.

  5. #5
    Junior Member
    Join Date
    Jul 2010
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: How to get name of Activated Menu Bar in Excel

    Hi Avinash,

    I am working on a project where we use Excel COM add-in where we need to test excel based functionality.

    So I have to automate activate particular menu bar(Like View,Insert) I had done this using send keys but some cases send keys not working or after send keys I need to validate that concerned menu bar is opened.

    Hope this will clear your doubts.

    Waiting for your reply.

    Thanks,
    Nilesh

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:27 AM.

Copyright BetaSoft Inc.