Last modified date in Excel cell

February 26, 2008 at 06:35:22
Specs: XP MS Office 2007, xx

Hi everyone,

I need some help here. I'm running excel MS office 2007. I have a main file that as a hyperlink to an external word doc. I'd like to place in an cell in the excel file the last modified date of the external word file. Any ideas from anyone?

Thanks...

Moti



See More: Last modified date in Excel cell

Report •


#1
February 26, 2008 at 17:22:36

Right click on the sheet tab for the sheet that has the hyperlink and select View code.

Paste the code below into the window that appears.

In the code, replace A1 with the cell where you want the info. (Leave the quotes)

Click on the hyperlink.

Let me know how that works for you.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Range("A1") = FileDateTime(Target.Address)
End Sub


Report •
Related Solutions


Ask Question