A French grandfather has admitted raping and sexually assaulting around 40 women in France and Belgium since the 1980s, officials say.