Or this

Sub test()
Shell "explorer.exe C:\Data", vbNormalFocus
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jake Marx" wrote in message ...
Hi Roger,

Roger B. wrote:
I would like a macro that opens the directory D:\VEST\spBackup so
that I can see the files inside.

If you simply want to open the folder in Windows Explorer, you can do something like this:

Public Sub gShowFolder(rsPath As String)
Dim sh As Object

Set sh = CreateObject("Shell.Application")
sh.Explore rsPath

Set sh = Nothing
End Sub

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]