Thread: getting the date a directory was created
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steven Revell Steven Revell is offline
external usenet poster
  
Posts: 35
Default getting the date a directory was created
I get an error "object variable or with variable not set"
at this line:

Set fld = fso.GetFolder("c:\windows")

Cheers for the help,
Steven


-----Original Message-----
active the Microsoft Scripting Runtime in references

then
Sub DirDate()
Dim fso As New Scripting.FileSystemObject
Dim fld As Scripting.Folder
Set fld = fso.GetFolder("c:\windows")
MsgBox fld.DateCreated
End Sub


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Steven Revell" wrote:

Hi,

I want to be able to find out the data that a directory
was created using VBA. Is it possible?

Thanks for any help,

Steven


.

Reply With QuoteReply With Quote