Results 1 to 2 of 2

Thread: Dates in Sharepoint site vs. Windows Explorer

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2009
    Posts
    1

    Question Dates in Sharepoint site vs. Windows Explorer

    Everyone:

    I'm new to the board.

    In using VBA 6.5, I am trying to get the last modified date of a .xls file on a Sharepoint site. In the sharepoint site, I columns that show Date Created and Date Modified. For instance, the first will be 6/1/09. The second will be 7/13/09. However, when I look at the same site through Windows explorer, I get a different date under the date modified column, say 6/16/09. Any reason why the date modified dates don't agree?

    In my code, I use the filedatetime(filename). However, this returns the date created. Can anyone provide help?

    Thanks.

    I've posted a similar question here:

    http://www.mrexcel.com/forum/showthread.php?t=402292
    Last edited by chicken; Jul 13th, 2009 at 07:08 PM. Reason: thread from another site

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: Dates in Sharepoint site vs. Windows Explorer

    Thread moved from "ASP, VBScript" forum to "Office Development/VBA" forum

Posting Permissions

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



Click Here to Expand Forum to Full Width