VBA, Search if file name exists in Network Drive
<p>Does anyone have a macro where I can input a list of file names in excel,(Full path in Col A) and search to see if they exist on a network drive(not local)?</p>

<p>Is it possible to show in Col B:</p>

<p>1) If file exists? (true or false)
 2) the timestamp of the file? (time file created and/or modified)</p>

<p>Tried searching for this, but would like to use a VBA code.</p>

<p>Example: Col A has my file names, and I want Col B to show if they exist in the network drive, and C showing the timestamp if it exits.</p>

<p>Thanks.</p>