We all use VBA macro to automate reports and for that we are very much dependent on Google. Google provides lot of information but at times it’s difficult to locate the right piece of information. This blog is created to share some useful VBA codes which can be used by professionals in their work. You will find ready to use codes and formulas to make your job easy.
Thursday, April 11, 2013
Importing data into Microsoft Excel using web query
MS Excel provides the facility to import data from excel sources. One way is by using Web Query. It is a very useful feature that Excel has. To create the Web Query:
Select the first cell in which you want results to appear.
Choose Data | Import External Data | New Web Query to open the dialog box shown in image below.
Enter the URL in Address box and click Go.
Select the table you want to use by using the check mark and click Import button.