TRajasankar Posted October 9, 2014 Share Posted October 9, 2014 Hi, I'm brand new here but have been tasked with a project to automate an excel add in for a web based application. We have a custom ribbon which allows for upload and retrieval of information from the web application with valid credentials. This also allows for the excel columns to be manipulated for the data needed. Basically put, what we want to do is to be able to click the custom ribbon, click through the ribbon pop ups, write to the excel cells, and upload or retrieve data from the web application. We also are looking for the ability to write pass/fail status results after each test case automation. I'm trying to figure out how to do this, what programming language would be needed, etc. I've been able to use the recorder to automate some of the tasks but we are looking for actual code which is more reliable and not workstation specific. I have attached some screenshots of what the ribbon looks like. I welcome any suggestions/help that can be offered. Thank you in advance Link to comment Share on other sites More sharing options...
13lack13lade Posted October 10, 2014 Share Posted October 10, 2014 are you wanting to automate doing all this clicking and data sending? If this is the case and you are working with Internet Explorer, you can simply use the IE commands in IE.au3 to control the elements etc. Have a look in the Autoit help file under _IE Link to comment Share on other sites More sharing options...
Bert Posted October 10, 2014 Share Posted October 10, 2014 (edited) are you wanting to automate doing all this clicking and data sending? If this is the case and you are working with Internet Explorer, you can simply use the IE commands in IE.au3 to control the elements etc. Have a look in the Autoit help file under _IE Facepalm - He is working with Excel. Did you not read the title? Yes, the addon communicates with the Internet however he is working in Excel. Edited October 10, 2014 by DarthCookieMonster The Vollatran project My blog: http://www.vollysinterestingshit.com/ Link to comment Share on other sites More sharing options...
Bert Posted October 10, 2014 Share Posted October 10, 2014 As you are working with commandbars, you should be able to automate this. What I may suggest is not use AutoIt and use Excel VBA to do it. That way you can simply run the macro inside Excel and get what you need done. Just use the macro recorder to get the basics then clean up the VBA script so it does what you need. The Vollatran project My blog: http://www.vollysinterestingshit.com/ Link to comment Share on other sites More sharing options...
junkew Posted October 10, 2014 Share Posted October 10, 2014 and if VBA is not working read the IUIAutomation thread in examples section which can deal with ribbons and commandbars FAQ 31 How to click some elements, FAQ 40 Test automation with AutoIt, Multithreading CLR .NET Powershell CMDLets Link to comment Share on other sites More sharing options...
TRajasankar Posted October 16, 2014 Author Share Posted October 16, 2014 Thanks for the advice. I'll try these ideas out and come back if I have any further questions. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now