>There doesn't seem to be much info here about MS Project and automation. Has anyone had any experience with this?

As I said elsewhere, this is a toughie due to the stupid naming of MS Project, it's difficult to do searches without getting almost all noise.

However, if you haven't seen it yet, check out MSKB Q163026, there is a little code there that might help get started. You can do macros like Excel to learn more code, if no other ideas pop up.