title: Assign image for footer to excel file and not an external path
body: <p>I am currently creating a template with a data validation to have a drop down with 5 different location name. On selection the appropriate address image is inserted into the excel footer. I plan to distribute the template but i need to save the images to the excel file because the current file path wont work for other users. </p>
  
  <p>any help much appreciated</p>
  
  <pre><code>ActiveSheet.PageSetup.LeftFooterPicture.Filename = _
          "X:\Adrian\19.0 Templates\19.1 Test\UK Footer address"
  </code></pre>