Opening a windows folder

[mcescher]

User would like to have a button that opens a folder. Like dblclicking
on My Computer.

Path will be built from some previously entered data. I can find it,
but how do I display the folder

Can a button open a shortcut to a folder? Could I update the path of
the shortcut?

Thanks,
Chris

 

[Guest]

This site has the code to call the Windows Common Dialog that includes file
names.
http://www.mvps.org/access/api/api0001.htm

This site only browes folders, You don't het file names.
http://www.mvps.org/access/api/api0002.htm

Either will allow you to code in defaults

 

[Dirk Goldgar]

User would like to have a button that opens a folder. Like
dblclicking on My Computer.

Path will be built from some previously entered data. I can find it,
but how do I display the folder

You could use the fHandleFile function posted at

http://www.mvps.org/access/api/api0018.htm
API: Start an app with ShellExecute

to open the folder:

strFolderPath = "C:\Temp" ' for example

fHandleFile strFolderPath, WIN_NORMAL

Or you could probably shell to Explorer:

Shell "explorer.exe " & Chr(34) & strFolderPath & Chr(34)

Can a button open a shortcut to a folder? Could I update the path of
the shortcut?

A button could open a shortcut, using a similar method, but you don't
need to if you have the path to the folder.