By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

accessing C drive

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
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.


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.