I understand that you would like to import data from the web using MATLAB functions. I assume that you are using MATLAB R2023b.
In MATLAB, you can perform web scraping using the built-in "webread", "websave", "webwrite" and "weboptions" functions. These are RESTful web services functions which allow non-programmers to access many web services using HTTP GET and POST methods. More details about them can be found on the documentation page: https://www.mathworks.com/help/matlab/internet-file-access.html
As for executing VBA code from MATLAB, you can use MATLAB's COM Automation Server support to interact with applications that support VBA, such as Excel, and execute VBA scripts within those applications. An example on doing this can be found on this MATLAB Answers post here: https://www.mathworks.com/matlabcentral/answers/100938-how-can-i-run-an-excel-macro-from-matlab
