Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to create a list of prices from a web page
I haven't written an excel macro since the early days of macros. With that said I am trying to look up and update a number of prices from lumber retailers online and then post to an excel spreadsheet. I can probably fumble my way through creating a loop, but I do not know how to go about passing a part number to the search routine on the various sites. McCoys.com makes this even more difficult as I was hoping to use concatenate the text of the string using a part number.
So if I search for McCoy's Part #: 010718 I will get a web address of http://shop.mccoys.com/building-mate...d-lumber/p.153 This does not help me locate the next item which may be concrete of something other then the directory tree layout of the URL. Thus is there a way to use VBA to feed the search function of the page to return just the value of the model numbers that I can seed from a spreadsheet? Any help to get me started is greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to create a list of prices from a web page
On Sunday, September 2, 2012 11:05:44 PM UTC-5, hsbminer wrote:
I haven't written an excel macro since the early days of macros. With that said I am trying to look up and update a number of prices from lumber retailers online and then post to an excel spreadsheet. I can probably fumble my way through creating a loop, but I do not know how to go about passing a part number to the search routine on the various sites. McCoys.com makes this even more difficult as I was hoping to use concatenate the text of the string using a part number. So if I search for McCoy's Part #: 010718 I will get a web address of http://shop.mccoys.com/building-mate...d-lumber/p.153 This does not help me locate the next item which may be concrete of something other then the directory tree layout of the URL. Thus is there a way to use VBA to feed the search function of the page to return just the value of the model numbers that I can seed from a spreadsheet? Any help to get me started is greatly appreciated. Thanks. I had a problem with the url provided in that it wouldn't let me do a search. Are you using an "external query" to get the data. Send your file, with a complete explanation to dguillett @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create a drop down list with prices in aswell | Excel Discussion (Misc queries) | |||
Create Summary List Page | Excel Discussion (Misc queries) | |||
I WOULD LIKE TO RANDOMLY GENERATE FROM LIST I CREATE ON SAME PAGE | Excel Programming | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
Create way to change data in list from another page | Excel Programming |