crazyeyeschase
Board Regular
- Joined
- May 6, 2014
- Messages
- 104
- Office Version
- 365
- Platform
- Windows
To begin I am rebuilding a vehicle and am currently working on sourcing parts from multiple vendors. I am not sure excel can perform what I want but I was once deep in the weeds with macros and enjoyed it and figured maybe I can use excel to speed this process of part/price sourcing.
What I am wanting to do is to have excel search a website for a part number and then input the price (at minimum) into a cell.
From what I have read and can tell the import from web will not work unless the vendor lists the info into a table which I could not figure out.
I think using xmlhttp might be an option but even then, from my little refresher today I think this only searches the current page and cant perform a search of the website.
Technically I need to search the entire website for the product, find the product page, then search the source code for the pricing or any other strings I need.
Obviously each vendor will have a different source code and the macro would need to be customizable to each site if this is even possible.
Can anyone point me in the right direction or if this is even possible?
I am still searching for myself but though I should get some professional feedback here.
What I am wanting to do is to have excel search a website for a part number and then input the price (at minimum) into a cell.
From what I have read and can tell the import from web will not work unless the vendor lists the info into a table which I could not figure out.
I think using xmlhttp might be an option but even then, from my little refresher today I think this only searches the current page and cant perform a search of the website.
Technically I need to search the entire website for the product, find the product page, then search the source code for the pricing or any other strings I need.
Obviously each vendor will have a different source code and the macro would need to be customizable to each site if this is even possible.
Can anyone point me in the right direction or if this is even possible?
I am still searching for myself but though I should get some professional feedback here.