Sir Paul McCartney says he traded his weed habit for margaritas and the occasional glass of red wine.