VBA: Can you open Windows Explorer from VBA?

=========
QUESTION
———
Can I open Windows Explorer from my VBA code?

 

=========
ANSWER
———
See EXAMPLES

 

=========
EXAMPLES
———
Private Sub WindowsExplorer_Click()

Dim rst As Recordset
Dim retval As String

Set rst = CurrentDb.OpenRecordset("Parms")
retval = Shell("explorer.exe " & rst!Path, vbNormalFocus)

Set rst = Nothing

End Sub

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
VBA
Windows Explorer

 

=========
REF
———
http://www.mrexcel.com/forum/showthread.php?t=10408

 


http://www.anysitesupport.com/access-vba-can-you-open-windows-explorer-from-vba/
http://anySiteHosting.com

By | 2011-06-15T13:27:19+00:00 June 15th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments