Hey everybody,
There is a website from which I can download a .csv file. I think the .csv file is not actually on the server but is generated with a php script.
At the moment I can not post the link but I can say that it ends with .php?... and because of that I think the .csv is created on the fly.
I have tried to import it with 'Data' -> 'From site' and 'From text' but it doesn't work. It only works with a direct link to a .csv file, I guess?
At the moment I Always delete the old file in 'my downloads' folder, go to the link, download and save the .csv and then do my thing with VBA.
My question now: is it possible to download and open the .csv automatically with VBA code (or just plain Excel)?
Many thanks