 |
| Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
January 4th, 2007, 08:22 AM
|
|
Authorized User
|
|
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
opening a folder location
hi,
would like a button that opens he folder created earlier by a procedure.
My question is what is the VBA to open a folder, im sure its a easy question for you guys!
Cheers
|
January 4th, 2007, 08:26 AM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
|
|
What do you mean "open a folder?"
mmcdonal
|
January 4th, 2007, 09:36 AM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Assuming you mean to open an Explorer window at the given folder location... try something like:
Call Shell("explorer.exe X:\Location\etc", vbNormalFocus)
|
January 4th, 2007, 01:48 PM
|
|
Authorized User
|
|
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
cheers how can i call the folder from a string?
|
January 4th, 2007, 05:42 PM
|
|
Registered User
|
|
Join Date: Oct 2006
Location: Leigh, Lancashire, United Kingdom.
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Do you mean to put a file in the folder or to physically open the folder to display it?
|
January 5th, 2007, 06:54 AM
|
|
Friend of Wrox
|
|
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Jonni,
What do you mean by: "... call the folder from a string"?
|
January 5th, 2007, 09:01 AM
|
|
Authorized User
|
|
Join Date: Jan 2007
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
sorry i was not sure how to formulate my question (obviously)
its working now,
Dim strShortcut As String
strShortcut = Me.txtShortcut
Call Shell("explorer.exe " & strShortcut, vbNormalFocus)
i had problems where i did not leave a space between .exe and the " but its working now, cheers for taking time to ponder my query
Jonni
|
|
Similar Threads
