Hi Tony,

I'm afraid VBA is not among my skills. You might try posting to the MS forum for Microsoft programming:
http://social.technet.microsoft.com/...ct2010custprog

If you post to the MS forum, let them know what version of Project and Excel you are using. Rod Gill's book excerpts may also help.

See: http://msdn.microsoft.com/en-us/libr...ffice.12).aspx