insert online data into excel

[va1damar]

I work for a retail company that has several thousand spreadsheets they use to make price comparisons between their price and those of competitors. Right now they have to visit the competitor's web page and copy the price and past it into the spreadsheet. They do this for something in the order of 40,000 products (don't ask me why someone thought this was the way to approach the problem - i have no idea).

I can write a perl script that goes out and grabs the price and returns it, but I don't know how to get the prices back into the excel spreadsheet. I don't have any restrictions on how I do this. My background is programming & I know very little about excel, so there may be a simple approach i'm just not familliar with. Thx all,

va1damar