Hi,
You need to use a range of features. Simplest way to do this is a Project or
Excel VBA macro or even a combination of both. My book has working examples
of everything you need, but there is no simple piece of code that will do
what you want, especially as you haven't told us that.
Try searching msdn.microsoft.com for office automation examples and then
post specific questions for difficulties you are having.
If you are new to Project and Excel VBA, it really will be significantly
cheaper and faster to get someone to write the code for you. Several people
in this group (including me
) can develop solutions for you, so just
ask.
--
Rod Gill
Project MVP
Project VBA Book, for details visit:
http://www.projectvbabook.com
NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx