title: Google apps spreadsheet parents folder ID
body: <p>I have a google spreadsheet that is keeping track of the files and their names that are inside the folder where the spreadsheet is.<br />
  I have looked and can not find how to get the location or ID of that sheet<br />
  In MS CMD script it would be "%~dp0".<br />
  How to do this in google apps spreadsheet script.<br /></p>
  
  <pre><code> function FnctnMenuUpdateGetLocation() {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
    var SSID=ss.get.getId();
    var file = DocsList.getFileById(SSID);
  
    Browser.msgBox(SSID);
    Browser.msgBox(add);
  }
  </code></pre>
  
  <p><a href="https://docs.google.com/spreadsheet/ccc?key=0AmsQN3N9km70dGwtLTJXVVBzbmJhdmE5OFpkbTVxelE&amp;usp=sharing" rel="noreferrer">https://docs.google.com/spreadsheet/ccc?key=0AmsQN3N9km70dGwtLTJXVVBzbmJhdmE5OFpkbTVxelE&amp;usp=sharing</a>
  ya, I am working in it<br />
  this is a live sheet<br /></p>
  
  <p>From what I have how do you get the address of the spreadsheet in google drive<br />
  from the spread sheet I will be having it add folder/dir and file that I need<br /></p>
  
  <p>since google docs is not google drive how is the interface from Spreadsheet to the google drive<br /></p>