Results 1 to 4 of 4

Thread: read file timestamp [RESOLVED]

  1. Jan 16th, 2006, 03:15 AM #1
    wvisser
    wvisser is offline

    Thread Starter
    Member
    Join Date
    Mar 2002
    Posts
    50

    Resolved read file timestamp [RESOLVED]

    People,

    I'm looking for a (simple) way to read the timestamp of files before reading the actual files into Excell. I would have thought this be a simple task but so far I've not been succesfull. Thnx in advance.
    Last edited by wvisser; Jan 16th, 2006 at 05:10 AM. Reason: [RESOLVED]
    Life is as short as you make it
    Reply With Quote Reply With Quote
  2. Jan 16th, 2006, 04:10 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: read file timestamp

    try reading about getattr function.
    Otherwise it might be FileSystemObject (class/reference).

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Jan 16th, 2006, 04:19 AM #3
    wvisser
    wvisser is offline

    Thread Starter
    Member
    Join Date
    Mar 2002
    Posts
    50

    Re: read file timestamp

    Ecniv,

    If tried FileSystemObject but this seems to be Vb property and unknown in VBA, which I am using. Or should I include some dll for this to work?

    The getattr property might be a way to get things done but I have not been able to read up on it since I have a limited help-function on this particular machine. Could you enlighten me?

    Thnx.
    Life is as short as you make it
    Reply With Quote Reply With Quote
  4. Jan 16th, 2006, 05:02 AM #4
    wvisser
    wvisser is offline

    Thread Starter
    Member
    Join Date
    Mar 2002
    Posts
    50

    Re: read file timestamp <RESOLVED>

    As Ecniv pointed out quit clearly FileSystemObject only works with a reference; this should be a reference to Microsoft Scripting Runtime. With this it works like a charme.

    Thnx again Ecniv.
    Life is as short as you make it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width