title: Relative Paths within Excel for CSV imports
body: <p>I have an Excel workbook that auto-updates the worksheets from CSV files. These pull in the data from a hard coded folder (c:\temp\premiumreports\name_of_CSV_file.csv).</p>
  
  <p>This method forces me to put everything into c:\temp\premiumreports everytime or if I send the file to a customer they have to create the same directory structure.</p>
  
  <p>I would like to place my xlsx file into any folder (c:\report or the user's desktop) with the necessary CSV files and when I open the xlsx the data is imported automatically. </p>
  
  <p>Current Workbook Connection<br>
  <a href="https://i.stack.imgur.com/MaQYc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MaQYc.png" alt="enter image description here"></a></p>