title: How to display the file name from the path name in combobox
body: <p>I have written a code which will extract all the sub folders which is present inside a particular folder/Directory. Here is the code.</p>
  
  <pre><code>ComboBox10.List = Split(CreateObject("wscript.shell").exec("cmd /c Dir ""C:\Users\inkapb\AppData\Local\Temp\EPC AutoTool\Projects\*."" /b /s").stdout.readall, vbCrLf)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/QD4WU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QD4WU.png" alt="enter image description here"></a></p>
  
  <p>Here in the above code all the sub folder path is getting populated instead of the subfolder name. 
  Can any one help me to achieve my requirement</p>