Automatically Format using Macros?

[danieldaniel]

Hello,

I am posting to the general thread because I am not sure where to pos
this question (if I am posting in the wrong area, please redirect me).


I was wondering if it is possible to format similar/same word document
automatically. For example, we pull data from a database that get
generated into a MS word file. Unfortunately, the document i
formatted incorrectly, so a person has to go in and manually make th
document look pretty (i.e. enlarge font, make columns in tables bigger
etc.).

Is it possible to automate this process? And if it is, is the best wa
using macros? I just need to be pointed in the right direction.


Much thanks,

Danie

 

[Cindy M -WordMVP-]

Hi Danieldaniel,

You can apply formatting during the "data drop" process using automation,
yes. Probably a good place to follow up on this would be one of the
word.vba groups; beginners if you have absolutely no programming
background, otherwise in general. Include the following information:

- Version of Word
- Whether you can control (change) the program generating the Word
document
- If not, the logic involved in identifying the portions of the doocument
that should be formatted automatically
- Exactly what kind of formatting you need
- Your programming background (if any)

I was wondering if it is possible to format similar/same word documents
automatically. For example, we pull data from a database that gets
generated into a MS word file. Unfortunately, the document is
formatted incorrectly, so a person has to go in and manually make the
document look pretty (i.e. enlarge font, make columns in tables bigger,
etc.).

Is it possible to automate this process? And if it is, is the best way
using macros? I just need to be pointed in the right direction.

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

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