This is out of the VBA help file. It opens a folder and returns info on the
filename included as folderspec.

Sub ShowFolderInfo(folderspec)
Dim fs, f, s,
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
s = f.DateCreated
MsgBox s
End Sub



"Andrew" wrote:

Is there an easy Macro to open Folders from Excel.VB..?
I'm Sure Ive done it before - but can't remember if it was a fs
object or something.

Thx for any Help/Feedback