Need software to automate a complicated task.

[X82]

I shall try to explain this complicated situation best I can.
We have an excel sheet with 4 tabs. Each tab contains a list of ip addresses (about 50 per tab) which need to be clicked on. It open's firefox (must be firefox because IE doesn't work with this site) and it brings up power readings for our power bars at work. In the page is a value in amps, which we have to remember, open a seperate excel sheet and type in the values for that one powerbar.

Then repeat for each ip address on that tab before moving on to the next tab. Also, all the ips require a username and password, but fortunately they are all the same, but its still tiresome.

Does anyone know of any software or script, vba or macro which can automate this task? Currently, it can take 4/5 hours to complete and they have to be done daily. Any advice on this will be so appreciated.

 

[Linkex]

Google autohotkey. You'll need to spend a couple of days getting to grips with it, but once you have, it will allow you to script this.

 

[X82]

I've had a look into it. Will this cover copying a reading from a webpage?
This procedure might get rolled out to all staff. I just worry if a dialogue box or browser window isn't in the exact correct position, the entire thing is thrown off.

But I am new to all this macro/hotkey business so forgive my ignorance.

Any more advice is appreciated.

 

[Linkex]

If you look at the file reading functions and the download to file function, it may be possible to do it all in the background and write the results to another file - no need to interact directly with excel or a browser at all

 

[X82]

I fear this is slightly out of my depth. I was hoping for a more GUI friendly software approach.

Does anyone have any alternatives or suggestions? In the meantime I will try to look into autohotkey a bit more. But I fear my brain would collapse in on itself.