insert online data into excel

va1damar

New Member
Joined
Oct 18, 2006
Messages
2
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
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Have you tried a Web Query - Data|Get External Data|New Web Query?

If you record a macro while doing it you will get some VBA code.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,735
Members
410,703
Latest member
yaronjoseph
Top