+ Reply to Thread
Results 1 to 4 of 4

Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Documents

  1. #1
    Registered User
    Join Date
    07-14-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Documents

    Hello, first time poster looking for a little help.


    I'm working in Excel 2007 and have a column which consists of hyperlinks to word documents held elsewhere on the same drive. Firstly, i was wondering how i would go about writing a macro so that in another column i could get the date last modified of the respective hyperlinks to appear. I think is possible as have managed to get a formula to work but only where there is one hyperlink on the sheet and i have no idea of how to scale it up to apply to an entire column.


    The other function I would like to be able to perform is to be able to open simultaneously the multiple hyperlinks in to one word document. I can combine the files from windows explorer, after a fashion, but was wondering if it might be possible to do so from the hyperlinks column in excel.


    I have looked around but haven't been able to find answers. I apologise if i am repeating posts.

    I hope someone among you can give me a little help and for that i would be very grateful.

    Many thanks

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Docume

    Hello mr butter,

    Welcome to the Forum!

    I think you mean the last modified date of the file opened by the hyperlink, correct? I am assuming also that the hyperlinks are formula based "=Hyperlink(Link Location, Friendly Name)". It will require a VBA macro to retrieve the file information. It would be helpful to see your workbook beforehand.

    It would be easy to write a macro to update the column when the workbook is first opened. After that, a button on the sheet could run the macro to refresh the dates as need. Let me know if this is an acceptable option.

    Word can be setup to open all files in the same instance, though this probably not an option you would want to use. A VBA macro can open the files for you in the same instance of Word, but a hyperlink can not.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    07-14-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Docume

    Thank you for the quick reply.

    I did indeed mean for the last modified date output to be that of the hyperlinked cell. I'm not 100% sure i understand what is meant by formula based hyperlinks. Please find attached a sample portion of the workbook so you can see the system i am running to. The full spreadsheet has about 400 such hyperlinks and didn't want to slow up the transit.

    It would be fine to have a button somewhere that would update the column rather than having to re-open the file itself to get the updates.

    If a macro can be set up to open all the files in the same instance of word this would also be very handy.

    Thank you again
    Attached Files Attached Files
    Last edited by mr butter; 07-15-2010 at 03:40 AM.

  4. #4
    Registered User
    Join Date
    07-14-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Date Last Modified of Hyperlinked Documents + Collaboration of Hyperlinked Docume

    I've managed to solve the second of the two problems now with a master document - sub document listing in Microsoft Word. It's a fiddle but works quite well for the purpose so please disregard the second question.

    Many thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1