title: VBA obtaining info from unopened workbook from shared drive
body: <p>I'm curious about what the format of a code in VBA for...  </p>
  
  <p>obtaining specific rows from a specific sheet from a specific workbook within a specific subset of folders.  </p>
  
  <p>for example: Populating Sheet1 in Wkbk1 from the data in Sheet1 from Wkbk2 which is in a shared drive somewhere....</p>
  
  <p>Any ideas?</p>
  
  <p>EDIT:  </p>
  
  <p>I realize this may be a vague post so I am going to try to explain in further detail.  </p>
  
  <p>I am looking for a code which allows me to do the following.  </p>
  
  <ul>
  <li>Enable a macro from WkBk 1 to pull data from WkBk 2.  </li>
  <li>WkBk 2 is located within a shared drive and is closed.  </li>
  <li>I want to pull specific data from WkBk 2 and populate that data into specific rows in WkBk 1.</li>
  </ul>