Sharing excel reference
 

I am develloping a .net application using excel automation. Me and my
colleague are having trouble with the excel reference. When i add the
reference and he does a get-latest, the excel reference is not found. If he
add it againg and i do a get latest i have the problem.

Now, i thought that this problem should be solved by referencing the office
PIA rather the COM object directly. I have yet to test that, but i'd like for
someone to comment on that approach.
Also, my dev environement is running Excel 2003 while production
environnement are running Excel 2002. So which PIA should i install and how
can i be sure that this will work on production...

Any feedback and comment on this will be appreciated.

Remi