Update Querytable linked to CSV file without having to select the file manually

Hi All,

I have a querytable linked to a CSV file. I want the querytable to update automatically. So far I have used this code:

Sub Makro1()

    Sheets("Sheet1").QueryTables("NameOfQueryTable").Refresh BackgroundQuery:=False
End Sub

The problem with this code is, that I have to select the file manually from a pop-up window. How can i programme it to link to one specifik CSV file every time without asking me?

I think I need to add a path somewhere in the code?

THanks for your help!

Kind Regards KRAND