title: Access VBA Renaming Files From Table Values
body: <p>I'm trying to create renaming script. There will be set of data in table.</p>
  
  <p>E.g. </p>
  
  <pre><code> OldName               NewName    Folder
  
   \\...\ABC\123.pdf     X000001      ABC
  
   \\...\ABC\124.pdf     X000002     ABC  
  
   \\...\XYZ\199.pdf     X000075     XYZ
  </code></pre>
  
  <p>I would like to rename only folder by folder. So before script is running there will be input box.</p>
  
  <p>I know how to rename files manually using </p>
  
  <pre><code>Name OldName As NewName 
  </code></pre>
  
  <p>How to create a loop for each files in directory - value form InputBox and rename them with corresponding NewName ? </p>