Web Automation

[oodai]

I am looking for an autoit solution to automate routine tasks at my office below are the steps i perform everyday.

Here are the steps

The process that i do is very manual and repeating same kind of steps every day

Below is the detailed steps and i ahve inlcuded the steps in attachment. I am looking for autmation solution

Step 1      Copy the Flexi Number from excel (Cell P3)       
Step 2      Click on Search button in webpage  paste the Flexi number in Search button in flexi button     
Step 3      Copy the store Number from excel  (Cell O3)  
                Click on Select a store button  in select store in webpage
Step 4      Pick date from excel (Cell G3)  and paste in webpage       
Step 5      Update account and paste it in account    

Select Each link in the page        
Step 7      Once the page is opened take screen print of the page and save to a folder

All the Geniuses could you pleasse help me automating this procedure? sample files attached

BR

Uday

 

 

screen print.docx

sample.xlsx

[Melba23]

oodai,

Welcome to the AutoIt forum.

But please pay attention to where you post - the "Examples" section where you started this thread is clearly marked: "This is NOT a general support forum!".  I have moved it for you, but would ask you to be more careful in future.

M23

[Danp2]

There are built-in functions for interacting with both Excel and IE. Suggest that you review those in the help file and then try writing the script yourself. Show us some code and someone will likely be able to assist you with any issues you run into.

[232showtime]

are you asking someone to code it for you? or you already made a script but Didn't Turn Out Like You Wanted It To?

[JLogan3o13]

oodai, welcome to the forum. I think what 232showtime is trying to point out, is that this forum is dedicated to assisting users with their scripts. We operate off the "teach a man to fish" motto, rather than you just putting in a request and someone doing it for you. For your question, I would suggest the following:

Step 1      Copy the Flexi Number from excel (Cell P3)

•    Look at the built-in Excel functions in the help file

Step 2      Click on Search button in webpage  paste the Flexi number in Search button in flexi button   

• Look at the _IE functions in the help file. 

I would start with those two steps, and make sure you understand how they work, before moving on. Once you have tried something on your own, feel free to post your script (even if it is not running as you would expect) and we will do what we can to assist.