Vba to import CSV via Chrome

[Dwg]

Hello !
I’m a real beginner in VBA , I need to created a report and I would like to automate it as much as possible . So I have a CSV file located on the web , I need to download it and copy paste it content in my report . To do so I created a first sub that open Chrome with the link of the file I need to download . No issue , file download automatically but in my personal user download folder and I will need to download it on a shared drive .
I thought that maybe I can use the delete and then move function ( as movefile only cannot overwrite ) but maybe there is a way to set the shared drive folder directly ?
Thanks for your help !

 

[jmacleary]

Hello there and welcome. Instead of a sub etc. why don't you create a data link directly to the file? You can do this from the Data tab, then choose Fron Text/CSV.

 

[Dwg]

Thank you ! I tried but it doesn’t work as to connect to this page we have to be logged to a external network accessing via OTP .

so the only solution I found was to already been log on the platform and then launching the macro to open Chrome and download the file .

for the moment I added a delete and then move function to put the file on the shared folder . It works ! Now I’m stuck at importing the data to my report ... real beginner ! Thanks for your help .