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

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
    ... 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: How to get data from txt file into table of word template thro
    ... 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 ... For the XML data source file, you said Word can parse it by itself. ...
    (microsoft.public.word.vba.general)
  • Strange performance behavior of IXMLDOMNode>>text in DPRO 5.1.4
    ... I have come a quite a way in building my own framework to parse a particular XML file (that contains information about audio tracks). ... After some more experimentation I also found that the bigger the XML file was, the longer each method execution took, even if it was for the same node at the same position. ...
    (comp.lang.smalltalk.dolphin)
  • RE: Bug in MSXML / XML Parser .Net
    ... > I have a problem parsing XML file using XSLT stylesheet by using: ... > System.Xml.XPath.MethodOperand.SetXsltContext(XsltContext context) ... > When I use XMLSpy to parse the XML using MSXML 4 processor it works perfect. ...
    (microsoft.public.dotnet.xml)
  • Re: How do programmers handle file paths to data when designing programs
    ... In general you keep program data with the program under "Program Files", then user data lives with each user who logs on to the machine and is kept in their profile under "Application Data\YourCompany", you can then put program settings either into an XML file, or store them under HKLM, the user settings go in either as and XML file or under HKCU. ... If the data is something the user actually creates and manages themselves (such as a Word document) you would simply offer "My Documents" as the OpenFile default. ... When i take that program to a client, they do not use the same paths that i do to store the data files needed by the program. ... I know i can use the fileopendialog method to get the path to the file, but once that is done, how do you save it for future executions of the program. ...
    (microsoft.public.vsnet.general)