I am new to VBA and have some beginning knowledge but not good for now for what I want to do.
So I was hoping to find someone who can help.
so this the issue atm.
I wont to download a CSV file from a specific address:
I have for now hidden our site as we can not give out the CSV file to the public atm. anyway if you click it, you will get a CSV file with tables and data in it.
What I am trying to make atm is that google sheets will download this file every night to a specific google drive location. later I will try to get other scripts to get the data of that file and paste its data inside google sheets.
I want to do this so we do not have to manually update our stock from our warehouse.
Thank you all in advance.