This may not be useful to anyone else but I put together some vba code that lets you pass in a hyperlink and it will tell you when the file was last modified.
In my situation I needed to manage a group of reports (in differing formats) that needed to be updated by their owners on a monthly basis. Towards the end of each month I send out a spreadsheet showing who has and hasn''t updated their reports. The spreadsheet I inherited includes links to each document so it made sense to me to have a formula read each hyperlink and return the last modified date on the file.
I decided to break the problem down into two formulas for a higher reuse value. One to return the hyperlink from a given cell as text. Another that will return the last modified date of a file given the full path name. The formulas are below, enjoy.
To create the following formulas you will need to go to Tools>Macro>Visual Basic Editor
and paste these into a module for the workbook you want to use these in. They will then be available in the user defined formulas. Also make sure you update the project references to include the Microsoft Scripting Runtime by going to Tools>Refernces inside the VBA window and making sure that it is checked in the list
get_hyperlink_filepath
Public Function get_hyperlink_filepath(cellRef As Range) As String
Dim fldrpath As String
Dim filepath As String
fldrpath = Application.ActiveWorkbook.path
filepath = cellRef.Hyperlinks(1).Address
get_hyperlink_filepath = fldrpath & "\\" & filepath
End Function
get_file_last_modified
Public Function get_file_last_modified(filepath As String) As Date
Dim fso As New FileSystemObject
Dim f As File
Dim d As Date
Set f = fso.GetFile(filepath)
get_file_last_modified = IIf(IsDate(f.DateLastModified), f.DateLastModified, Null)
End Function
First time masturbating video
First time masturbating video-Movies of a precious blonde teen takes off her panties to masturbate
Sexy teens nude pictures- Movies of two innocent girls getting their pink pussies banged
Online nude mexican teen-Movies of a kind mommy shows this airhead teen how to get fucked
Really naked fat girls pictures-Movies of three skanks find random guys at the gym for group sex
Free sexy amateur women video- Movies of a playful milf that loves any dick thats inside her
Free naked hot women porn- Movies of two 18 year old teens both get fucked from behind
Blowjob women free movies- Movies of a wet teen in a bikini getting fucked in the pool
Girl showin pussy porn- Various young girlfriends showing off their tits and ass
Black girls intercourse movie- Movies of a submissive brunette fucked for a crowd at a shop
Boys naked and sexy girls-Movies of a hung guy taking turns fucking mother and daughter
Free nude movies of babes-Movies of tiny tits teens shown taking fat cocks
Free indian porn clips- Petite teen cutie in schoolgirl uniform showing her sweet pink pussy
Pussy eating porn- Movies and pics showing snobby teens talking husbands into fucking
Naked pictures of my girlfriend- Movies of athletic teen athletes getting banged after practice
Lesbain teen first time-Movies of a blonde milf going to town on a big dick
Mature woman how love sex
Mature woman how love sex -Movies of a hung dude taking turns fucking two dumb blondes.
Free amateur gang bang pic-Movies of a petite college whore takes it balls deep in the ass.
Free interracial gang bang pic-Home made amateur pics with real naked girlfriends exposed on camera
Teen gang bang sex video-Blonde milf gets her shaved pussy filled with cum on the sofa.
Free juicy pantie thumbnail wet - movies of a young blonde hooks up online with a stud.
Live russian porno
Young naked preteen girls porno
Teen preteen hardcore sex porn
Mature porn picture
Black mature women porn clips
Preteen nude porn
Porn russian preteen
Under age porn movies
Dirty teen porn websites
Long hardcore sex movie
French anal porn
Free black anal porn
Naked lesbian pornstars
Schoolgirls fuck porn
Amateur with natural big boob
Amateur with natural big boob-Cori the natural milf shows off her big juicy tits
Free big tit blonde movie-Samantha babe plays with big boobs and poses in bed
Big tit porn star movie-Movies of beauty blonde babe with nylons on and high heels
Big tit anal sex movie-Movies of a glamorous redhead babe squirting like crazy
Double pussy anal fuck video
Anal sex horses porn video
Huge dicks porn video
Anna Nicole Smith sex videos free
Internal cumshot video
Fuck me suck me video
Young sex porns best trailers
Hardcore cunt fucking porn
Hot teen masturbation video
Free sweet ass porn
Woman in sexy underwear
Private anal video
Teens first anal sex
Crazy black girls porn movies
Mature brunettes in nylons porn
Chubby girl hose in pantie
Chubby girl hose in pantie-Movies of a blonde and horny college hottie banged hard on a couch
Amateur girl fucked on a party-Movies of busty Alektra Blue gets exposed and fucked on sofa
Busty girlfriend fucked hardHot stacked brunette in red underwear posing
Amateur with massive titsMovies of a little blonde slut getting double fucked hard
Young asian with hairy pussy-Hot and sexy fotos of different amateur teens.
Sexy teen blonde squirt-Horny amateur party girls getting kinky together.
Blondie hardcore action videos-Movies of a hottie gets her tight hairy pussy fingered and fucked.
Hot blondie ally gets-Three delightful cuties lustily lick tasty quims in kitchen.
Free naked black foot pics- Movies of a young blondie drilled in her gaping asshole
Babe big boob fucked sexy-Movies of a big tits blonde teen student fucked by her teacher
Pretty girl with big boob- Movies and pics showing older men seducing gullible teen babysitters
Amateur teen pussy pictures-Movies of crazy women waiting their turn to pleasure male dacners
?iwc gst perpetual calendar
?The legendary jewelry
best japanese watch house proves its horological mastery again this year with a number of new models for men and women. The highlight of the 2003 collection
breitling by bentley is undoubtedly the Opus 3, which Harry Winston developed with master watchmaker and AHCI member Vianney Halter. Look for
breitling uhren an in-depth review of the innovative Opus 3 in an upcoming issue of International Wristwatch. A unique
buy chronoswiss concept developed with Vianney Halter, Opus 3 is a world premier in movement, function and form. Movement Manual-wind in German
cartier women watches silver with full digit display and no hands by Vianney Halter; 2 going trains and twin barrels; 53 jewels; 21,600 bph;
designer replica purses 40-hour power reserve; digit display by means of 10 discs incorporated into the bottom plate Functions Jumping hours, mi>nutes,
hublot watch seconds and date Case 18-karat rose gold or platinum (platinum model can be set with baguette and brilliant-cut diamonds for a total weight of 4.44 carats); 36x52.5mm; 8 sapphire crystals, including sapphire crystal exhibition caseback; water-resistant to 30m Dial 6 windows indicating the hours, minutes, seconds
iwc replicas
iwc top gun
iwc watch prices
iwc wrist watches
james bond watches
ladies watch replica
link tiger woods
luminor daylight
luxury swiss watch
montblanc watchesnew tag heuer formula 1
panerai 231
panerai automatic watch
panerai chrono
panerai luminor gmt titanium
panerai pam 197
panerai radiomir 8 days
panerai regatta
panerai watch replica
patek
patek philip calatrava
patek philippe 24 watch
patek philippe 5052
wow gold
AC Milan will not be cycling past a bicycle x-0208 wow
gold, Heikki: I have the image in the McLaren and wow power
leveling, really an iron fist military guy cheap wow
gold,W Villa Atletico have been a draw buy wow
gold,Video - Robinho stunning heels to break World of Warcraft
Gold. Correctional ball Pa Capello is
watching Baixinho match the outbreakwow
gold, England captain to reflect thewow power
leveling,exit to meet the coaching staff on cheap wow
gold,straight victories at home buy wow
gold, Correctional ball Pa Capello is World of Warcraft
Gold. reverse the Celtics get two pairs of
hair straightener
watching Baixinho match the outbreak ghd hair straightener,Low-energy peak is like children chi hair straightener,W Villa Atletico have been a draw ghd hair,Yan Qiang: See Kunitari, very angry! chi hair,Taylor went back sigh undone NBDL ghd hair straightener,Chelsea, Inter Milan battle strong Array chi hair straightener,claim Manjuan Shishu hi mad ghd hair,Terry VS Woods "Xingxingxiangxi" chi hair,Kaka Robinho Micro Bauzin owner hair straightener straight victories by the Red ghd hair straightener, Kunitari continuation hair flat Pride Prejudice Dewey Kunitari bloody hair straight, Qinghua both bound to be corrupt? hair straight,Stepford Wives girlfriend altar Jing-Yan ghd hair straightener,Devils blue double play Arsenal hair flat,family and I watch the battle hair straightener Baixinho performance beast blog, revealing
watches
go home after the New Year wishes to replica watches,for Tan Wangsong Luneng Serie replica watches Wind vane: Beijing and Henan competition replica watches,a record-breaking event replica watches.Wenger says referee deposit Lou Pan
louis vuitton
the watch list, starting a chain louis vuitton,Lang Xiaonong all alone, excluding louis vuitton. See more angry? louis vuitton 21 was the main injury-Atletico end?ended 16 forcing the 32