french film help....SOLVED

hi, i'm hoping someone could tell me the name of a film i watched a few years back.

the basis of the story, hopefully not to vague....the main character is a traveling salesman, whos not particually happy in his job, or life generally. during the film he is partnered up with another male colleague, and are sent out traveling together on business. it is quite clear the pair are 'losers' particularly the main charcters new work partner.

the films main storyline then evolves around the pair trying to reinvigorate their lives/cling onto their youth, visiting nightclubs, trying to pull (unsuccessfully), even contemplating rape.....this is a black comedy, and am sure the ending scene finishes with the main character joining a dance class, and meeting a women, who both instantly click. don't think there is any dialogue in this scene, but their eyes engage, and you can see hes about to find true happiness.....

any ideas?
cheers.