Activate Window Explorer

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

My Access program outputs a number of files to a preset
directory. I'd like to automate the following in the VBA
program.
1. open and pop up the window explorer
2. change directory against a preset path and list all
the files in the directory.

Your help is greatly appreciated. Thanks,

Kevin
 
Ken,
Thanks for your prompt reply. Your suggested code is to
open file dialog box. What I want is simply a code or
function to activate the window explorer and have it
displayed on screen. My original intention was to assure
the users that the files were output correctly to the
destination.

Kevin
 
Private Sub Command8_Click()
Shell "explorer.exe ""D:\MSDN""", vbNormalFocus
End Sub

to open Windows Explorer with the path D:\MSDN selected.

HTH
Van T. Dinh
MVP (Access)
 
Many thanks. This is exactly what I asked for. The more
I work with MS Access, the more I like it.
 
Back
Top