hi, i'm ash n i'm new to VB n such. i need help to build a program to read a certain txt file n transfer it into excel (xls) file. i really really appreciates any help that i could get... p/s: tried to look into the internet but found nothing...no luck i guess. thank u in advance.
I'm not sure whether that can be done, unless the text file was originally created by saving a table through excel as a text file. You'll have to use code to read a text file. Something like this: Code: open textfile1.txt for input as #1