Molecular gas and dust in spiral galaxies