Pricing from homedepot.com

bgolpmp

New Member
Joined
Jul 4, 2015
Messages
11
I am an electrical contractor that uses excel to quote jobs. I am getting sick of looking on homedepot.com to check prices. I am looking for a way to have look up the price for me. I tried data from web and putting the website in there but I always get errors on the page and I cant add the table. I can add the whole page but when I press import it just locks up.
Is there a better way to do this? Or is it not possible.

Thanks

Andy
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hello bgolpmp,

Home Depot has a web based API that is free to use. However, you do need to setup an account to login to the web site.

Have a look at this link...
Home Depot Product API
 
Upvote 0
Thanks for the reply

I don't know excel all that great so this might be over my head but I am going to give it a try. I will have to do more digging on the net to help me with this

Andy
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top