A 96th-minute goal from substitute Harvey Macadam gave Morecambe a vital three points at Harrogate Town.