Open folder with vb

[d1novak]

I have a script that is attached to an access button that backs up the database to c:\database backup.

on the tail of the script I would like windows to open that folder for the user to view all the files.

Is this possible? or is browseforfolder all there is?

Thanks

 

[PHV]

You may try something like this:
Set Sh = CreateObject("WSCript.Shell")
Sh.Run "\Path\to\folder"
Set Sh = Nothing

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244