Excel Macro: Auto Data Refresh

I need a rock-solid VBA routine that will sit inside my workbook, reach out to a specific website (it isn’t a social, e-commerce, or news portal), pull the numeric figures I’m tracking, and drop them straight into a designated sheet. The fetch must trigger automatically every two minutes without me touching the keyboard and should do so even while the file remains open and I’m working in other sheets. The site returns clean numbers—prices, counts, or similar metrics—so there’s no heavy text parsing, but you will still need to handle possible latency or timeout gracefully. A simple status cell or message box that tells me the last successful pull would be helpful. Please code natively in VBA using standard Excel objects (QueryTable, XMLHTTP, or whichever method you feel is most reliable). No external add-ins or paid libraries. Deliverables • A self-contained macro module, fully commented • A quick setup note showing where to enter the URL and target cell range • Proof the refresh loop runs exactly every two minutes and can be paused or stopped with a single flag or button I’ll test by leaving the sheet open for at least ten minutes to confirm four consecutive updates land as expected.

Project ID: 39738921