Hello everbody,

I have a complex problem. I have made a study over 200 companies where I
compare all these companies in a graph. This graph is a line graph with an
arrow at place of the company. These graphs are in excel. Now I have to make
200 reports in word for each company. For each company I have another graph,
because the arrow is on another place. Therefor I use links in word.

What have I at the moment?
In excel: If i give in the number of the company, I have the right graphic
with the arrow at the right place.
In word: a standard document with a link to excel.

Is it possible to write a macro where i can do the following steps:
- starting from excel with all my number of companies
- take the first number and put it in my graph excel
- open word with links to excel (more than 100 links)
- update all the links
- remove these links
- save as "company name"
- next number and start from the beginning.

Otherwise I have to this manually and this will take a lot of my time.

Is there anyone who can help me?

thanks a lot,
Jan