[AccessD] Ideas wanted for Office project requirements

 Hi all,

Slightly OT.  

I have a client who wants to automate a report writing process.

Currently they have about 30 managers who once a month send either a
Excel workbook or Word doc to
some lucky person.  He/she then extracts the contents of each file and
pastes it into a Word doc to be made into
a report.

I don't do much with Office these days so maybe someone will have an
easy solution???

Step 1
My favoured idea so far is to create a Com-addin for Word/Excel that
will take selected text/objects
and paste them into a blank file, the copy the file to a file share.

Step 2 the person who collates the files has another addin that loops
through the contents of the share
dir and opens and copies the contents into fields/bookmarks(?) in a Word
doc.

A 3rd component may be needed to sync the whole schmoozle.


I wonder how sturdy a process like this would be...

All responses welcome (except abuse... lol)

cheers



Michael M