We often use Excel during working to record or deal with data for it has a powerful function to calculate data. Usually, we export or update data to Excel manually. It will be a big project if there is thousand of information needed to deal with. VBA macro helps users to realize Excel automation by using object and offers kinds a large number of methods and properties of each object class to control Excel. However, it is also a trouble when we want to get data from outside source even if usin...