Browse button in VB form

[Vinay2479]

Hi all,

Does any one knows how to create a Browse button in VB form.
I want a browse button in my VB form. In the macro I want to select a folder by using the browse button as we do in windows explorer.

Vinay

 

[TheTick]

You need to use Windows API to do this. Folder Browser and Common Dialog objects are not licensed in VBA.

<

http://www.daniweb.com/forums/thread14061.html>

Honesty may be the best policy, but insanity is a better defense.

http://www.EsoxRepublic.com

-SolidWorks API VB programming help

 

[Vinay2479]

Thanks.
Do I need to get VB6 to do this?

 

[TheTick]

It works in VBA. The "Declare" statements can not be in a form, though. They need to reside in a code module.

 

[Vinay2479]

Thank you.
I will try.

 

[brengine]

This is a pretty good example too:

http://www.oaltd.co.uk/DLCount/DLCount.asp?file=BrowseForFolder.zip

Ken

 

[Vinay2479]

I tried to implement browseforfolder example with solidworks.
Its giving an error of a dll not found.

This is the part of code where its is giving error

Private Declare Function GetCurrentVbaProject _
Lib "vba332.dll" Alias "EbGetExecutingProj" _
(hProject As Long) As Long
Private Declare Function GetFuncID _
Lib "vba332.dll" Alias "TipGetFunctionId" _
(ByVal hProject As Long, ByVal strFunctionName As String, _
ByRef strFunctionId As String) As Long
Private Declare Function GetAddr _
Lib "vba332.dll" Alias "TipGetLpfnOfFunctionId" _
(ByVal hProject As Long, ByVal strFunctionId As String, _
ByRef lpfn As Long) As Long

Which dll name I have to specify for solidworks VBA to work?


Vinay