<div>
Try this:<br />
<br />
If Dir(&quot;C:\YourPath&quot;, vbDirectory) &lt;&gt;&nbsp;&quot;&quot; Then MsgBox &quot;Folder exists&quot;<br />
<br />
:-)<br />
ah<br />

</div>


Try this:

If Dir("C:\YourPath", vbDirectory) <> "" Then MsgBox "Folder exists"

:-)
ah


<div>
You are really the expert of all experts .... ^.^
</div>


You are really the expert of all experts .... ^.^

<div>
Stanley,<br />
Like a one-trick pony, I'm an expert proficient only in Excel questions, alas.<br />
<br />
Thanks for the grade!<br />
Brad
</div>


Stanley,
Like a one-trick pony, I'm an expert proficient only in Excel questions, alas.

Thanks for the grade!
Brad

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Just would like to know how to check the existance of a certain folder in Excel VBA. &nbsp;Thanks.<br />
<br />
Stanley
</div>
</div>


Hi,

Just would like to know how to check the existance of a certain folder in Excel VBA.  Thanks.

Stanley

Excel VBA : check the existance of a folder in VBA

Windows 2000 is an operating system for use on both client and server computers. It is the successor to Windows NT 4.0, and is the last version of Microsoft Windows to display the "Windows NT" designation. Four editions of Windows 2000 were released (Professional, Server, Advanced Server, and Datacenter Server) that shared a core set of features, including many system utilities such as the Microsoft Management Console. All versions of the operating system support NTFS 3.0, Encrypting File System, as well as basic and dynamic disk storage. The Windows 2000 Server family includes support for Active Directory services, Distributed File System and fault-redundant storage volumes.

Windows 2000

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.