Sending out a general help request here for a problem I'm trying to
solve.  I've tried a bunch of different avenues, and programs, and
can't get any to work EXACTLY the way I need it to.

Essentially, I have a directory, let's just say R:\DATA for this
examples sake.  In R:\DATA there are a couple of thousand (yes)
folders, each of which contains a few files.  I have a Access sub
that, based on certain criteria, tells me which folders in R:\DATA I
need to put on an outgoing CD.

The only way I'm able to do it right now is to make access log the
directories to a file, open that log file, and manually select each
folder in an explorer window, then drag them to Corel CD Creator.

What I would REALLY like to be able to do is have Access start up a
copy of Exploer, select each folder in the exploer window, then leave
it for me to just drag and drop in Corel.

I'm not very familiar with DDE, so I'm not sure that is the direction
I need to go in.  I scoured through the Win32 API but couldn't find
anything that looked helpful.

Any ideas?  Thanks a lot.

Adam,

I don't know if you will be able to *select* all files, but it should
be easy to open an Explorer window to a specific folder.  You can use
the SHELL function to start Explorer with a given pathname; the
command line would look like

C:\WINDOWS\EXPLORER.EXE /n,/e,R:\DATA\SUB1234\

You can find more info about the SHELL function in the help files.
Hope this helps.