Activate Window Explorer

[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 Snell]

Try the code at this page of The ACCESS Web:
http://www.mvps.org/access/api/api0001.htm

 

[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

 

[Van T. Dinh]

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)

 

[Kevin]

Many thanks. This is exactly what I asked for. The more
I work with MS Access, the more I like it.