<div>
See <a href="http://www.erlandsendata.no/english/vba/folders/index.htm" rel="ugc">http://www.erlandsendata.no/english/vba/folders/index.htm</a>
</div>


See http://www.erlandsendata.no/english/vba/folders/index.htm [http://www.erlandsendata.no/english/vba/folders/index.htm]

<div>
Thanks a lot, this is what exactly i was looking for.<br />
<br />

</div>


Thanks a lot, this is what exactly i was looking for.



<div>
And you got it twice....<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi all, <br />
How to open the Open File Window for user to choose a specific FOLDER (not file) ?<br />
<br />
coz the macro tat i am doing need user to specific a target folder to work on, and i am going to put a 'BROWSE' command button for that purpose<br />
After user has select the target path, the path will be shown in a textbox as well.<br />
<br />
Can anyone tell me how to do that? And what library to be included ?<br />
<br />

</div>
</div>


Hi all, 
How to open the Open File Window for user to choose a specific FOLDER (not file) ?

coz the macro tat i am doing need user to specific a target folder to work on, and i am going to put a 'BROWSE' command button for that purpose
After user has select the target path, the path will be shown in a textbox as well.

Can anyone tell me how to do that? And what library to be included ?



Open File CmdDialog

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.