Automatically refresh

[Gus Cappi]

HI,

I have a macro that updates some worksheets with others .csv files, but I'm using the code:

Range("A3").Select
Selection.QueryTable.Refresh BackgroundQuery:=False

(The A3 cell is where I imported the text file initially)

Is there any way that I can specify a path for a file and it updates automatically??

Thanks!

 

[Gus Cappi]

I tried this:

Range("A3").Select
With ActiveSheet.QueryTables(1)
.Connection = "TEXT;C:\teste 1903\" & uest & "TAB6.txt"
.Refresh False
End With

But it continues with the pop-up screen.....