In our company, the SEO specilaist writes reports in Excel for clients at the end of each month. As we've become more sucessful, the number of reports has increased. However, much of this information comes from Agent Web Ranking, and the process of migrating it from this to Excel is laborious, time-consuming and un-productive.
So, we've had the hair-brained scheme of paying someone to build a program that will automate this, grabbing data from AWR and putting it in our Excel template, but how to go about it? It's at the very edge of my expertise and I'm guessing it would involve some .NET and XML jiggery pokery.
Can anyone recommend what tools/language would be the best way to go about this?