Thread: Opens directory
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Opens directory

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]