choosing folder in vba-access

[thread]

Hi All

i'm trying to build a parallel function in vba access that appear in
excel:

FileDialog(msoFileDialogFolderPicker)

does anyone know how to choose only a folder through VBA in Access?

[Larry Linson]

"thread" <ya******@gmail.comwrote in message
news:7c**********************************@l32g2000 hse.googlegroups.com...

Hi All

i'm trying to build a parallel function in vba access that appear in
excel:

FileDialog(msoFileDialogFolderPicker)

does anyone know how to choose only a folder through VBA in Access?

Code for using the Windows API function "Browse for Folder" can be found at
http://www.mvps.org/access/api/api0002.htm. That site, by the way, is laden
with good information and tips -- it's a resource you ought to remember.

And, one comment... I believe the Excel method you describe requires an
ActiveX control, with attendant hassles in including and distributing the
ActiveX. The API method does not... it uses Windows functions that are
already on the user's machine.

Larry Linson
Microsoft Access MVP