To begin, let’s use VBA to grab the HTML source code from a specific URL through the use of the InternetExplorer object. After that, we can bring that HTML source code straight into the Power Query and through its transformation features such as specifying the appropriate tags and attributes, it will help extract the required data. All of these with parameters in both VBA and Power Query steps for the purpose of achieving flexibility. This means that you are able to change the direction of the web page and even the method of data extraction without having to modify the VBA code