C drive folders

[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.

 

[Joseph Meehan]

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.

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[Dirk Goldgar]

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.

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