There's a version of the song in David Herd's Scots' Songs', 1776 [Napolean then being 7 years old]. James Oswald had published the tune "The Lowlands of Holland" in book 2 of 'The Caledonian Pocket Companion', c 1745. The song with a different tune is in 'The Scots Musical Museum;, II, #115, 1788.