Re: How to get data from txt file into table of word template through

It's like asking "How do I drive from Paris to Moscow, where do I turn
left?"

There's a whole heap of commands for parsing strings. You could use Split()
to divide the lines up by the commas. Or maybe just dump the lot into Excel
and use the Text-to-columns function.

As before: what have you tried so far, and what went wrong?




"sam" <shang.gao.uu@xxxxxxxxx> wrote in message
news:1145523468.960035.218380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

Thank you for answer!

As the data info in the txt.file is not in standard table format, How
can I extract the exactly data info from the txt.file.

The data format in txt file is something like this:

Sam, (27, US, +1-513-1389, sam@xxxxxxxxx)
Lisa: (UK, 28, +44-318900, Lisa@xxxxxxxxx)

the table in word template has two column, and it gives out the name
info:
Name Telephone
Sam
Lisa
...

It is possible to extract info from TXT.file and insert into table in
word using VBA. Could you give me some coding info for this sample?

Best Regards

Sam



.

Loading