Automating a data export

[Brad]

Is there any way to have only a subset of data contained
in a word document exported to either an access database
or excel worksheet at the time the document is saved? I
would need records (or cells) appended on an ongoing basis
each time a document is saved (it will be a new document
each time created from a template). Any ideas?

 

[Cindy Meister -WordMVP-]

Hi Brad,

Is there any way to have only a subset of data contained
in a word document exported to either an access database
or excel worksheet at the time the document is saved? I
would need records (or cells) appended on an ongoing basis
each time a document is saved (it will be a new document
each time created from a template). Any ideas?

The template needs a FileSave and FileSaveAs macro to trigger
the actions.

The code would save the data to the database, then save the
document (or show the dialog box). That's about all we can
really tell you, since we have absolutely no idea how the
document will be constructed. You have to have some way to
identify what you're going to extract, and where it should
go.

We'd also need to know which version of Word you'd be using.

Note that Word 2003 with XML and SmartDocument
technology would probably the most ideal situation for you...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Brad]

-----Original Message-----
Hi Brad,

The template needs a FileSave and FileSaveAs macro to trigger
the actions.

The code would save the data to the database, then save the
document (or show the dialog box). That's about all we can
really tell you, since we have absolutely no idea how the
document will be constructed. You have to have some way to
identify what you're going to extract, and where it should
go.

We'd also need to know which version of Word you'd be using.

Note that Word 2003 with XML and SmartDocument
technology would probably the most ideal situation for you...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

.

Thx Cindy,

It would be Word 2000 (no plans for the upgrade yet). Yes
we would know the exact location of the data that would
need to be extracted. Right now a form is constructed for
returns. Customer service fills out this form from a
template (using just basic checkbox and text fields) laid
out in a standard table. It can be modified if need be.
The information we would like to track would just be the
reason for return... we are encountering many shipping
errors, as well as defective items.

Thx in advance,
Brad Otsuka

 

[Cindy Meister -WordMVP-]

Hi Brad,

It would be Word 2000 (no plans for the upgrade yet).

And no need Still probably the best "every day working"
version that uses VBA. (Don't get me wrong, I like the later
versions and use them; but overall 2000 is a very good
version.)

Right now a form is constructed for
returns. Customer service fills out this form from a
template (using just basic checkbox and text fields) laid
out in a standard table.

Excellent. Then it's simply a matter of picking up the
formfield results, which can be done using the form field
name.

Do you (or anyone in your group) have any experience
automating Excel, or Access or using DAO or ADO?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail