Instead of using the IE object, we will use the 'xmlhttp' object, which is also available in VBA. It's also much more difficult to loop through data. The IE object is generally slow and doesn't perform well with large amounts of data. The IE object is useful if you know that your users have Internet Explorer installed and you only have a small amount of data to download. VBA has an Internet Explorer option to download data. In our example, we will loop through a table of data to gather its information and place it in the local Excel spreadsheet. When working with Excel, you normally want to extract data contained in tables or sections of the page. In this section, we'll show you how to open a web page and extract data from it. You will want to read data from the Internet far more often than you will write data to the Internet.
In this article, we'll discuss how you can connect to the Internet, read information from a web page, and then write data back to the Internet.
You can both read data from the Internet and even upload data to a remote cloud server. For instance, you might need to pull data from a third-party database or scrape data from a web page. You can retrieve data directly from the Internet to make it more useful and convenient to users. Most applications must work with the Internet (also called the cloud) to keep real-time numbers.
