Excel HomeDepot & Lowes Scraper

Customer: AI | Published: 11.02.2026

I need an .xlsm workbook whose VBA macro fetches product data from both homedepot.com and lowes.com. When I type a valid item or model number into a row, the code should automatically pull back: product name, full description, regular price, sale price (if available), brand, product type/category, and the main image (inserted into the sheet or stored in an Image column). I work comfortably with VBA, so a concise, well-commented routine is all I need—no step-by-step user guide. The workbook must stay self-contained, relying only on standard references such as Microsoft XML, HTML, or WinHTTP libraries; please avoid external add-ins or Python bridges. Deliverables: • Finished macro-enabled Excel file (.xlsm) ready to test with my own SKU list • Clearly commented VBA code so I can extend it later • Note of any library references that must be enabled No calculation or analysis is required beyond placing the raw fields in their respective columns.