VBA with Word Tables

[kb]

I have a few Word documents that are generated by some
third party software. The software pulls its data
through a Word 2000 template, drops data into Word
tables, and then saves off as a .rtf file. Two things
that I would like to do:

1. Is there a way for VBA to get to the value that's in
the cells of the tables? and

2. If I can get to that, is there a way to use VBA from
within Word to take those values and put them into a
database using ADO (.NET?), DAO, ODBC, ...?

Thanks!
Ken

 

[Jezebel]

Yes to both.

 

[kb]

Thank you, that was really helpful.

-----Original Message-----
Yes to both.





.

 

[Alex Ivanov]

activedocument.Tables(1).Cell(1,1).Range.Text

Is this more helpful?

Alex.

 

[Helmut Weber]

Hi Ken,
Jezebel's answer is indeed very helpful, as the most
important thing is to find out at first, whether
a problem can be solved at all. Now that you know,
(trust Jezebel), it can be solved, be confident on
your search for a solution. At present, to write data
to a very simple but easily accessable DBase-File,
i am using
Microsoft ADO Data Control, Version 6.0 (OLEDB) and
this connection-string:
Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="DSN=dBASE-Dateien;DBQ=D:\UB3
\CO\DATA;DefaultDir=D:\UB3
\CO\DATA;DriverId=533;FILEDSN=C:\Programme\Gemeinsame
Dateien\ODBC\Data Sources\dBASE-Dateien (not
sharable).dsn;MaxBufferSize=2048;PageTimeout=5;"
Keep on!
Greetings from Bavaria, Germany
Helmut Weber
"red.sys" & chr$(64) & "t-online.de"
Word 97, W98

 

[Jezebel]

I wasn't trying to be clever. Both questions are way too big to answer very
usefully with code snippets. People can post bits of code for you -- as did
the other posters -- but that's nowhere near enough information for you to
complete a project starting from scratch. You really are going to have to do
some homework on this one , look for examples in Help and elsewhere, learn
about the object model, etc etc: all of which you can search for with
confidence knowing that the answers really are there to find.

 

[kb]

Sorry, didn't mean to come across as crass there. While
I've dabbled in VB, I'm more of a SAS and SQL
programmer. Why they chose Word as part of their data
handling application is a mystery to me. Guess I'll add
Word programmer to the resume after I figure out how to
solve this one.

I do appreciate the pointers, Thanks!
Ken