Following from this thread: Repeating Macro On Multiple Files In Order
Hi All! I think my level its quite bellow Chris before writting this post! ha. Even thow I think I could manage the code that you had gently provide. The thing is, the text files that I want to open are written with a same pattern, but I dont know if I can open all using the same code. Should I write it down every time?
The main idea is to run the following with all the files from the folder:
Workbooks.OpenText Filename:= _
"C:\U***s\G*****N\D*****ads\A****a\files\yyyymmdd.DAT", _
Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _
Array(Array(0, 1), Array(7, 1), Array(51, 1), Array(75, 1), Array(85, 1), Array(101, 1), _
Array(110, 1), Array(118, 1)), TrailingMinusNumbers:=True
Range("A1").Select
Hope you can help me, (pleasse!!!!)
Thanks a lot!
Santi.
Hi All! I think my level its quite bellow Chris before writting this post! ha. Even thow I think I could manage the code that you had gently provide. The thing is, the text files that I want to open are written with a same pattern, but I dont know if I can open all using the same code. Should I write it down every time?
The main idea is to run the following with all the files from the folder:
Workbooks.OpenText Filename:= _
"C:\U***s\G*****N\D*****ads\A****a\files\yyyymmdd.DAT", _
Origin:=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:= _
Array(Array(0, 1), Array(7, 1), Array(51, 1), Array(75, 1), Array(85, 1), Array(101, 1), _
Array(110, 1), Array(118, 1)), TrailingMinusNumbers:=True
Range("A1").Select
Hope you can help me, (pleasse!!!!)
Thanks a lot!
Santi.
Last edited by a moderator: