Results 1 to 2 of 2

Thread: Needed!! Excel Macro -> Hyperlink file creation date and time.

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Posts
    3

    Post

    Hey all

    I have a cell which has a hyperlink to a file on our server. I want to be able to get the file creation date and time and place them in the adjacent cell.

    Any ideas??

    Thanks a lot

  2. #2
    Hyperactive Member
    Join Date
    Jun 1999
    Location
    Calgary Alberta
    Posts
    359

    Post

    From the VBA Macro Help in Excel

    FileDateTime Function

    Returns a Variant (Date) that indicates the date and time when a file was created or last modified.

    Syntax

    FileDateTime(pathname)

    The required pathname argument is a string expression that specifies a file name. The pathname may include the directory or folder, and the drive.

    So replace the 'pathname' with the hyperlinked file and it will return the date and time which you could seperate and put in. Hope this helps. I haven't actually used it, let me know if it doesn't and I'll give it a shot.

    Matthew
    matthewbryan@hotmail.com

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