Ramsay, John, active 1793-1807, Colonel