Can I use VS 2010 UI recorder to automate Excel? RRS feed

  • Question

  • Hi,

    We designed a product which is a COM Addin to Excel, and am trying to automate a scenario using VS 2010's UI recorder - looks like it is not working.

    Can someone please point me in the right direction for how to do this?

    1. Open Excel
    2. Load a file using our menu item (which is an addin to Excel)
    3. Save and close Excel

    Currently it works till opening Excel, but nothing happens after that. I also tried recording native Excel scenario like 'Open Excel', 'Enter some text in one of the cell', 'Save and Close Excel' - even that one is not recording correctly.

    Is it possible to automate this from VS 2010 UI recorder? or am I really spending time on something that is not supported? Please help!



    • Edited by Aruna Akella Thursday, October 21, 2010 8:07 PM added notes
    Thursday, October 21, 2010 7:55 PM


  • Aruna, Excel is not supported.


    Please mark this post as answer if this answers your question
    • Marked as answer by Aruna Akella Thursday, October 21, 2010 9:10 PM
    Thursday, October 21, 2010 8:26 PM

All replies