Browse Folder Button - Run external program

[Rafael]

All,

I want to add the following two items to my Access 2003 project/form:

1. A button that will allow a user to browse and select a folder
- Once the folder is selected, I want to capture the folder full path as
a variable
2. I want to be able to run an external program from a button on my form
using vba (example: myProgram.exe /para1 /para2)

Thank you,

Rafael

 

[Rafael]

I realized I can use the Shell.Run() command to run the external program so
all I need help with at this point is adding a folder chooser control on my
form.

Thanks,

Rafael

 

[Douglas J. Steele]

http://www.mvps.org/access/api/api0002.htm at "The Access Web"

 

[Guest]

Go to this site. This is what you need:
http://www.mvps.org/access/api/api0001.htm

 

[Rafael]

This code is exactly what I needed.

Thanks,

Rafael