SPONSORS:






User Tag List

Results 1 to 6 of 6
  1. #1
    Junior Member
    Join Date
    Jan 2000
    Location
    India
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to capture Microsoft Excel applications using silk.

    WE have The following version of Silk, Silk Release 1.1 and QA organiser Release 4.2. We are trying to capture windows for the Microsoft Excel applications, but are unable to do so. For ex, we cannot capture,the contents of the open dialog box also we cannot capture the all the contents of the main window.
    Looking forward for replies.
    Nitasha

  2. #2
    Guest

    Re: How to capture Microsoft Excel applications using silk.

    Silk Test not good on it at all
    For example in WinRunner or TeamTest or QARun you can at least define
    area where you going to capture a text. Or you write in a script that
    you want to click mouse at certain location.
    If you have a lot of custom windows like MS Office work with Silk
    extremely hard.


    am


    In article <200001210507.XAA28245@demeter.host4u.net>,
    nitasha thakur <nitasha_thakur@hotmail.com.nospam> wrote:
    > WE have The following version of Silk, Silk Release 1.1 and QA
    organiser Release 4.2. We are trying to capture windows for the
    Microsoft Excel applications, but are unable to do so. For ex, we
    cannot capture,the contents of the open dialog box also we cannot
    capture the all the contents of the main window.
    > Looking forward for replies.
    > Nitasha
    >
    > Please click the following link to reply:
    > http://www.qaforums.com/boards/ubb/F...ML/000130.html

    Lokis
    zippys@my-deja.com

  3. #3
    Guest

    Re: How to capture Microsoft Excel applications using silk.

    It's known problem and I met with that not only when wrote testcases for
    Microsoft Word and Excel.. Of Course, Maybe WinRunner is better for this
    task (I don't know because I've had no experience of using WinRunner) but
    you can declare custom Controls in SilkTest. See SilkTest User guide for
    detail how to manipulate with Custom Controls.

    Best regards,
    Andrew

  4. #4
    Junior Member
    Join Date
    Mar 2000
    Location
    Redwood City, CA, US
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: How to capture Microsoft Excel applications using silk.

    Use a "press keys" method and use the short keys on dialog boxes instead of clicking buttons.
    <BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by nitasha thakur:
    WE have The following version of Silk, Silk Release 1.1 and QA organiser Release 4.2. We are trying to capture windows for the Microsoft Excel applications, but are unable to do so. For ex, we cannot capture,the contents of the open dialog box also we cannot capture the all the contents of the main window.
    Looking forward for replies.
    Nitasha
    <HR></BLOCKQUOTE>


  5. #5
    Senior Member
    Join Date
    Dec 1999
    Location
    Chicago,Illinois,USA
    Posts
    2,537
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Re: How to capture Microsoft Excel applications using silk.

    This can sometimes be a problem - especially with Excel. I had a situation where I had to use Excel to generate some reports and I wanted Silk to handle this by going in, clicking a few buttons, and then getting out.

    I had a few ways of doing this. One way that I had some luck with was I had some VBA macros in my Excel sheet that did some of the work for me so all I had to do was automate the calling of Excel and the pressing of a few buttons (which I did by ALT keys). (For example, I would have a macro save my file for me or I would have the macro generate the pivot table.)

    These were somewhat special situations, however, because I was not so much trying to automate Excel as I was some functionality designed into some Excel sheets. Depending on what you are automating and why, you might want to determine if it is, in fact, something that should be automated. Many times I found it made more sense to write VBA macros and use those for my automation or to just do something manually.


  6. #6
    Senior Member
    Join Date
    Jul 1999
    Location
    Burlingame CA 94010
    Posts
    502
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: How to capture Microsoft Excel applications using silk.

    I've never tried this, but there's an ODBC driver available for Excel. If the spreadsheet was set up properly, you could retrieve and set its contents using DB_Connect, etc.

    Hope this helps.

    ------------------
    John W Green
    jwgreen@automationexpertise.com http://www.automationexpertise.com

    [This message has been edited by John Green (edited 03-20-2000).]

 

 

Posting Permissions

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

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin 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 12:41 PM.

Copyright BetaSoft Inc.