Hello Excel Gurus,
I currently have a VBA macro in a Excel xlsm file which opens a webpage then copy&paste the content of the webpage into a cell
But it's not very practical.
I would like to modify the following code to change the copy and paste function TO a download xls from web and import function, can you
help me to do it, because for downloading a xls file, and pasting the content in a cell.. i'm lost and even with much searches on the web
I can't find the way to do it ..
The code I'm actually using :
Then the last part of the code ( ieApp.Navigate.... userstat) repeats for each user...
So, how I can modify the part of this code for downloading a .xls file from web then importing in a cell ?