accessing C drive

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

[Wayne Phillips]

Use the 'RunApp' action and type something like this into the Command Line
argument:

explorer.exe C:\program files\abc

If that doesn't work you might have to put the full path to 'explorer.exe'
which is usually something like C:\WINDOWS\Explorer.exe

Regards,

Wayne Phillips
http://www.everythingaccess.com

"Jo K." <g4****@hotmail.com> wrote in message
news:42***********************@news.optusnet.com.a u...

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.

[Jim Evans]

Try placing your path within doudle quotes. That is the only way I have been
able to refer to a file or folder on a drive.
eg "c:\program files\abc"

Jim Evans
"Jo K." <g4****@hotmail.com> wrote in message
news:42***********************@news.optusnet.com.a u...

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.

[Salad]

Jo K. wrote:

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.

Use RunCode in the macro. Checkout ShellExecute in Help.

You might want to look at http://www.mvps.org/access/api/api0001.htm or
http://www.mvps.org/access/api/api0002.htm if you want to return a value

[Wayne Phillips]

Works fine without the quotes in XP... but yes you're right, it probably
should have the quotes.

"Jim Evans" <ji*@microsoftdiscussions.com> wrote in message
news:11*************@corp.supernews.com...

Try placing your path within doudle quotes. That is the only way I have been able to refer to a file or folder on a drive.
eg "c:\program files\abc"

Jim Evans
"Jo K." <g4****@hotmail.com> wrote in message
news:42***********************@news.optusnet.com.a u...

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.