I have multiple text files (.txt) with Tab delimited in a folder. The text file contains first line as column headings. I have one pre defined excel template with column names. I am able to import the text files into excel template. But, what i need to do is how to delimit if the column heading not match with Excel column headings Through VBA. Thanks in advance for any help .....
It's possible to do it in Excel itself, in Office 2010 its in the Data tab > Text to columns. There you can select that its delimited by tabs, and there you go, your data should be columnised
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With