Greetings and thanks to everyone in advance that helps me.
I am required to create a large scale document for my company. The only problem is I am not familar enough with excel, word, and VBA to accomplish this goal with out some help.
Components:
I have a large number of multi-paged excel work books.
end result:
For each excel work book I want to have a word document generated.
compilcations:
I am an average excel user.
Each page of the excel document has a table on it. Each table will have four charts generated from its data.
I must copy these charts and table to a word document for each excel workbook. (I am concentrating on only doing one before trying to tackle the whole issue)
The charts and tables must fit the format for each page.
Each page could have a differnt format from the one before. There are a limited number of formats.
I need this done in a few weeks can anyone point me in the right direction or maybe even a completely new direction.
Thanks again,
Axiom