what's the best way to make this script

Hey guys, Hopefully someone can tell me the best way to make this script.

I have several excel files with about 500-600 entries. I have to copy and paste each entry into a website and it pulls up a report. Then I have to copy a line from the report into another website which gives me the info I really need.

I want to create a script that has keyboard hot keys. So if I'm on the excel file and hit "z" it will copy the box I'm on and paste it into the search box on the designated website. Then when the search is complete I would hit "x" and it would copy the line of text I need and paste it into the other website that will be open in another browser window.

How hard would something like this be to make? And What language would you recommend?

thanks

You could make it in PHP/Python and run it off localhost, so you wouldn't even need to hot-key it and it would do everything for you.

I don't think I can automate it fully. I would be doing the work for a company and the websites I have to use are subscription based. Their policies state that no automation software can be used. I'm thinking that a hot key script would save me a ton of time and still allow me to stay within the ballpark of their policies.

Also, I might end up just paying someone to do this for me. If I went that route, would someone be able to complete this without me giving them my login details? Like I said, the site it subscription based, so there is no way to get into it without logging in. Would I be able to just scrape the html code from the site and have them design the script to paste the text in the appropriate area? Hopefully I explained that well enough to make sense.

Hmm I would do it in python - but in your case I recommend you to use a normal Macro program ... did not used one for ages so I can not recommend you a good one. But with a good macro program your hotkey solution should be no problem

Save the excel document to CSV, it is much easier to work with in script.