Suggestion wanted on automation of a word document 1

[DataHugger]

I have just been informed that there are going to be several large reports due out by my company in about 4 weeks. These books consist mostly of tables and graphs.

This is a large volume of information and each table and each graph will have the same position on each page for n page.

I have just started working at the company and I have just graduated college and this task feels a little beyond me because I am not extremely familar with the VBA, Word, and Excel that I think will be needed to automate this project.

I am just asking for places to start and tackle this goliath.

Thx.
-datahugger

 

[Dreamboat]

Call me.
Hee hee.

Actually, create a template NOW.
Include any objects that will appear in ALL documents.
Create autotext entries if you're not sure WHERE they'll appear. Autotext can be used for creating a table layout too (i.e., call it instable).
On open, have the template remove the formatting toolbar and throw up your own so they're forced to use your styles (tho the sample doesn't use styles):

http://www.vbaexpress.com/kb/getarticle.php?kb_id=14

Create styles for virtually every item they'll use:

tableheading
tablebullet
tabletext

figurecaption
tablecaption

and so on... don't miss any!

I've got a write up on creating styles and templates:

http://www.theofficeexperts.com/NewsLetters/June2002.doc

Good luck!

Anne Troy
Killer Coder Live Chat!

http://www.vbaexpress.com/forum/showthread.php?p=2121

 

[fumei]

Excellent advice Anne. specially like the suggestion to remove the format toolbar, and replace it with the styles from the template. I do the same.

Datahugger - this is not a trivial exercise - creating a template that will work efficiently for lagre documents. As Anne stated...get on it NOW.. If you have design people that can help with the layout, get on it ASAP. Rge actual template will take enough of your time.

Post back here if you need suggestions and pointers. There are great people in this forum.

I don't know how experienced you are, but if you are going to use headers and footers, and different sections...I strongly suggest whenEVER you make a new section, immediately, repeat immediately, make three or four page breaks (so blank pages) and set your headers and footers for them. You can delete the blank pages after that, if needed. Word stores the first created header/footer information in the section break itself. Any text inserted after, and thereby making new pages will automatically use the initial information. A lot of people have problems with header/footers when they try to fix them after putting text/graphics in the body text. Save yourself a headache...do them first.


Gerry

 

[DataHugger]

So I had several projects that got in the way of this one, but now I have a deadline for this and need to complete it.

I have all the formats/templates that I need for the various different sections.

Now for my question:
I have alot of premade excell files that contain the various information for the document. I need to get this data from the excel document into the word document. In the word document it will appear as tables and graphs. My orignal approach through VBA didn't work because I was foolish in my execution.



So what is the best way to get this information from excel into a word document in the desired form that I wanted.