Results 1 to 2 of 2

Thread: Dates in Sharepoint site vs. Windows Explorer

Threaded View

  1. Jul 13th, 2009, 07:04 PM #1
    chicken
    chicken is offline

    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
    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