C drive folders

J

Jo K.

I'm trying to setup a macro to be able to open up the windows explore box to
access the list of my c drive folders.
What action type would i use to enable the macro to do this ?

eg c:\program files\abc

thanks.
 
D

Dirk Goldgar

Jo K. said:
I'm trying to setup a macro to be able to open up the windows explore
box to access the list of my c drive folders.
What action type would i use to enable the macro to do this ?

eg c:\program files\abc

thanks.
Click to expand...

On the chance that you are trying to do this from Access, you can't do
it with the macro language, but you can use VBA to call the Windows
Browse For Folder dialog. See the code at:

http://www.mvps.org/access/api/api0002.htm
 
Top