This is my current macros:
ActiveSheet.Unprotect
With ActiveSheet.QueryTables.Add(Connection:="TEXT;U:TOIMPORT.txt", _
Destination:=Range("A4"))
.Name = "TOIMPORT"
.FieldNames = True
.RowNumbers = False... etc. etc.
Instead of TOIMPORT (which is a re-naming), how can I get Excel to find a text file where the last few characters (in this case *used at.txt) are always the same. The text file is generated by another system (where the last few char. are the same). Can I use a wildcard? I tried the "*" and it didn't work.
This message was edited by ammdumas on 2002-04-23 11:53
ActiveSheet.Unprotect
With ActiveSheet.QueryTables.Add(Connection:="TEXT;U:TOIMPORT.txt", _
Destination:=Range("A4"))
.Name = "TOIMPORT"
.FieldNames = True
.RowNumbers = False... etc. etc.
Instead of TOIMPORT (which is a re-naming), how can I get Excel to find a text file where the last few characters (in this case *used at.txt) are always the same. The text file is generated by another system (where the last few char. are the same). Can I use a wildcard? I tried the "*" and it didn't work.
This message was edited by ammdumas on 2002-04-23 11:53