With ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;" & ThisWorkbook.Path & "\1.txt", Destination:=Range("$A$1"))
.Refresh BackgroundQuery:=False
with the above code , i am getting the error 1004 "excel can not find the text file to refresh this external range"
pl advise
Obvious question: does the file exist in the same path\folder as the workbook containing the macro?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
macro is in personal.xlsb
text file and excel file are in same folder
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks