Throughout the 1970s Reed was a heavy user of methamphetamine and alcohol.  Metal Machine Music (1975) was an hour of modulated feedback and guitar effects. Critics interpreted it as a gesture of contempt, an attempt to break his contract with RCA or to alienate his less sophisticated fans. Reed claimed that the album was a genuine artistic effort, even suggesting that quotations of classical music could be found buried in the feedback. Lester Bangs declared it "genius", though also psychologically disturbing. The album was reportedly returned to stores by the thousands and was withdrawn after a few weeks.  1976's Coney Island Baby still drew on the underbelly of city life. At this time his lover was a transgender woman, Rachel, mentioned in the dedication of "Coney Island Baby" and appearing in the photos on the cover of Reed's 1977 "best of" album, Walk on the Wild Side: The Best of Lou Reed. Rock and Roll Heart was his 1976 debut for his new record label Arista, and Street Hassle (1978) was released in the midst of the punk scene he had helped to inspire. Reed took on a watchful, competitive and sometimes dismissive attitude towards punk. Aware that he had inspired them, he regularly attended shows at CBGB to track the artistic and commercial development of numerous punk bands, and a cover illustration and interview of Reed appeared in the first issue of Punk by Legs McNeil.  In 1978 Reed released his third live album, Live: Take No Prisoners, which some critics thought was his "bravest work yet," while others considered it his "silliest." Rolling Stone described it as "one of the funniest live albums ever recorded" and compared Reed's monologues with those of Lenny Bruce. Reed felt it was his best album to date.  The Bells (1979) featured jazz trumpeter Don Cherry. Around this period Reed also appeared as a sleazy record producer in Paul Simon's film One-Trick Pony. From around 1979 Reed began to wean himself off drugs.

Answer this question "When did he get over it" by extracting the answer from the text above.
From around 1979 Reed began to wean himself off drugs.