I know how to convert text to columns but am having a challenge conceptually with the VBA as it relates to the FieldInfo:=Array.
I would like to create generic code to open a flat file and convert the text to column. Since this would be generic code, the total elements in the array would change based on the flat file being used.
Your thoughts would be appreciated,
John
Text To Column
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Text To Column
Regards,
John
John
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Text To Column
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Text To Column
Nice link Hans. TXHansV wrote:See Dynamic TextToColumns (building an Array) - How How HOW!!!!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California