I do not work with VBA code so I'm afraid I can be of very limited help. However, instead of attempting to copy/paste you may have better success working through a direct export.

See the link below for an excerpt from Rod Gill's (Project MVP) book on Project VBA.

http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

Julie