sub test()
Sheets("data").Columns("A:AO").ClearContents
With Sheets("data").QueryTables.Add(Connection:= _
"TEXT;ThisWorkbook.Path &\Rawdata.csv", Destination:=Sheets("data").Range("$A$1"))
.TextFileCommaDelimiter = True
.Refresh BackgroundQuery:=False
End With
end sub
Sub test()
Sheets("data").Columns("A:AO").ClearContents
With Sheets("data").QueryTables.Add(Connection:= _
"TEXT;" & ThisWorkbook.Path & "\Rawdata.csv", Destination:=Sheets("data").Range("$A$1"))
.TextFileCommaDelimiter = True
.Refresh BackgroundQuery:=False
End With
End sub
Sub test()
Sheets("data").Columns("A:AO").ClearContents
With Sheets("data").QueryTables.Add(Connection:= _
"TEXT;" & ThisWorkbook.Path & "\Rawdata.csv", Destination:=Sheets("data").Range("$A$1"))
.TextFileCommaDelimiter = True
.Refresh BackgroundQuery:=False
End With
End sub