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

Tech-Archive recommends: Speed Up your PC by fixing your registry

hi,Jezebel

Anyway, Thank you for your help!

If I have further question, I will come back to you!:)

Regards

Sam

"Jezebel" wrote:

It's called a transformation, and it's nothing to do with semantic webs or
scientific perspectives. It's part of the functionality of Word.

Apart from which, itseems to me that we're going around in circles. Which I
guess makes sense, since you seem determined to reinvent the wheel. But
specifically: YES, VBA is well able to pull data from a text file and
populate a table in a Word document.




"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:770A3DA1-5708-4699-8E1F-C9AF6E1BF106@xxxxxxxxxxxxxxxx
Yes,I see. Based on some requirement or condition, we can derive some info
from XML directly. From a scientific perspective, I think what you have
mentioned is related to the issue about sematic web? Am i right? It is
also
popular topic nowsdays.
However,for this time, I Just assume that I need to populate the info into
word document.:) Did you have some relevant experience on the issue? If
so,
could you give me some suggestion?

Regards

Sam

"Jezebel" wrote:

Why do you need a Word document, and what does it give you that can't be
derived directly from the XML?




"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:285CCEDE-60A5-4F72-91FC-EB5DFDE45E70@xxxxxxxxxxxxxxxx
Hi,

First, not all customer info need to be in the word document. The word
template can tell me what kind of customer and correspondent info it
needed.
Secondly, the word template also regulate the layout of text and table.
So
I
think we need to populate cells in the tables based on word document.

Regards

Sam



"Jezebel" wrote:

It's like asking which is the best car for driving to Nebraska. Why do
you
need to populate the tables in the Word document at all? Why not write
an
XLST file to transform the XML file into the output you need?



"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9C342F3C-5F6B-4773-BE7F-C2A5DDCE7C86@xxxxxxxxxxxxxxxx
HI,Jezebel

I assumed one problem like this:
I have a XML file including all customer info in detail which is
regards
as
data source.
<?xml version="1.0"?>
<Catalog>
<Customer>
<Name>Bob</Name>
<COUNTRY>USA</COUNTRY>
<COMPANY>IBM</COMPANY>
<Email>Bob@xxxxxxxx</Email>
</Customer>
<Customer>
<Name>Sam</Name>
<COUNTRY>USA</COUNTRY>
<COMPANY>Apple</COMPANY>
<Email>Sam@xxxxxxxx</Email>
</Customer>
......
</Catalog>

On the other hand, I have a word document which has a lot of tables
inside.
here it is one example of the table in word document,
name | Company | Email
Nina
Laura

There are also other tables with some more or less columns. the
common
thing
of all the tables is: only the specific info of name column is given
out.
Normally, I need first find info in XML file(all the info can be
found
in
XML
file) and fill the table manually. It wastes time.

I think it is possible to populate the specific info from XML file
into
Specific cell in the table using some programming. In this manner,
it
can
generate the final document with all required info automatically.

What is your idea? Could you give me some suggestions?Which
programming
lanuage is the best one to solve this problem. Thank u!

Best Regards

Sam

"Jezebel" wrote:

Word and XML: this is well covered in Word's own documentation.
Word
can
open an XML file, and show a pane to display the tags etc. Excel
can
also
work directly with XML files.

There's no way to answer the question about whether VBA is the best
solution
without knowing the problem. It's obviously a good method for
working
with
Word documents; but given that its days are numbered, you might be
better
with VB.Net; or piss off Microsoft entirely and work with Java.




"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9999E420-C7EE-45BC-BBDE-CC0AD21FEEC5@xxxxxxxxxxxxxxxx
HI, Jezebel

Absolutely, I think you have got my problems. I am a little bit
confused
on
these two issues. A lot of new ideas came out during these days.
first
i
want
to parse data souce and then populate the specifc data into Word?
Is
VBA
the
best solution? or something else is better?

For the XML data source file, you said Word can parse it by
itself.
you
mean
field in word can parse XML file or other applications? Could you
elaborate
it a bit more for me?

Thank you again !!!!!!

Sam


"Jezebel" wrote:

This is a big topic, and it's not at all obvious what you're
asking.
By
definition, XML is easiest to parse because it's structured
specifically
to
be parsable; but if it's XML why bother with VBA? -- why not let
Word
or
Excel parse it for you? TXT and DOC files are parsable to the
extent
that
they're structured (they are, at least, easy to read). You can't
do
anything
with a PDF without converting it to something else first (which
isn't
always
possible).

You seem to be asking two questions: 1) how to parse a source
file,
and
2)
how to use VBA to populate a Word document. These are entirely
separate
issues. Stay with the literature.




"Sam" <Sam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AC441C83-7121-4151-ADC9-43BCA1E1181D@xxxxxxxxxxxxxxxx
HI, Jezebel:

Actually,I am new user to VBA programming. Now i am reading
literature
in
this field. I am thinking about the best way to load data into
table
of
Word.
I haven't done any test in pratical VBA progarmming. IF the
data
source
file
can be in PDF, DOC, TXT or XML format, which one is the best
one
to
parse
using VBA? Do you have some experience on this issue? And
could
you
recommend
some relevant material to me?

Thanks In advance!

Regards

Sam

"Jezebel" wrote:

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




.

Relevant Pages

  • Re: How to get data from txt file into table of word template thro
    ... However,for this time, I Just assume that I need to populate the info into ... derived directly from the XML? ... not all customer info need to be in the word document. ... There's no way to answer the question about whether VBA is the best ...
    (microsoft.public.word.vba.general)
  • Re: word webpages
    ... I suppose the problem is that XML, HTML in Word is intended for another thing as opposed to website material. ... My experience with DreamWeaver is very, ... HTML simply isn't powerful enough to describe a Word document. ...
    (microsoft.public.mac.office.word)
  • Re: word webpages
    ... both Word and DreamWeaver will enable the user ... to decide that they don't need some parts of the Word document in their web ... XML all versions ... When Microsoft first included the ...
    (microsoft.public.mac.office.word)
  • Re: How to get data from txt file into table of word template thro
    ... not all customer info need to be in the word document. ... XLST file to transform the XML file into the output you need? ... There's no way to answer the question about whether VBA is the best ...
    (microsoft.public.word.vba.general)
  • Re: XML Feed Dotnet
    ... What does the XML look like that you're using? ... same third party dont appear to have any time lag. ... third party to receive data in XML format which i then want to display ... I have the part where i populate the dataset but how do i search within ...
    (microsoft.public.dotnet.framework.aspnet)