Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Date/Time (VBA XP)

    We're about to distribute our templates and forms for our XP project and would like to give all of the files the same date and time. Is there a utility that will, for example, set the date and time for all of the files in a folder to a specified date/time?

    Thanks,
    Richard Barrett

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Date/Time (VBA XP)

    PC Magazine, now part of ZDnet, had a free one a long time ago. I think the name was "touch" or maybe that was the verb they used in the description of it. I'm sure there are many others.

    If you need to automate this, you could use the Shell command or the Windows Script Host's Shell.Run command. Or a batch file. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Last but not least, you can set internal properties using dsofile.exe. See Microsoft Knowledge Base Article 224351 - Dsofile.exe Lets You Edit Office Document Properties from Visual Basic and ASP. This way, you might be able to set a "version" indicator, perhaps as a custom document property, for finer control. (Otherwise, someone could change the date by modifying the template in some manner, such as saving AutoText, a macro, toolbar, or key assignment in it.)

    Hope this doesn't add too many hours to your project!

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Date/Time (VBA XP)

    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Re: Date/Time (VBA XP)

    This will work nicely. Thank you.

Posting Permissions

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