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
Bookmarks