VBA development in a team environment

Does anyone have experience in developing a single file in a team environment?  I have been working on this file by myself, but we have finally added one more person.  I know you can't share a file that has a VBA project.  So how do you go about working on the same file? 

Thanks 

I have not done this myself however seen it earlier.  You can use code versioning software like CVS or can also use vba code compare from http://www.formulasoft.com/ which I found really cool. You can create some kind of automation to create daily builds also by importing code modules from 2 or more files once everybody finishes the job and who are working on different modules.

JWiser:

...So how do you go about working on the same file?

You don't.

You work on separate copies, then one or the other of you merges the other person's code into their own workbook.

Best if one of you can work on udfs or procedures for importing data from other sources or interacting with outside systems while the other works on macros that manipulate workbook objects. That way your separate code should have the fewest number of inconsistencies to reconcile.