Saving time when updating

[singlgl1]

I have a file that links to 31 different files to grab one value from each.
The filepath for each is shown below, only the date changes for each.
When my file updates all links it is rather slow and the user will frequently elect not to update at all.
I'd like to have a code in place that would only update the file that corresponds to the date that the file is opened,for example today(7-10-11) when I open it I'd like to automatically update only the link below and so on.
'H:\Morning Reports 2011\Jul\[7-10-11.xls]Production'!$AA$30)

Hope this makes sense, if not I can clarify further.
Any help will be appreciated as this will speed up the process and still get the info I need.
Thanks in advance.

 

[GlennUK]

To examine links in a sheet and test which one to update, I'd think something like this would work:

mylinkarray = ActiveWorkbook.LinkSources
strtest = Format(Date, "yyyy\\mmm") & "\" & Format(Date, "m-d-yy")
For Each lnk In mylinkarray
    If InStr(1, lnk, strtest) > 0 Then
        ActiveWorkbook.UpdateLink (lnk)
    End If
Next

Is that the kind of thing you were after? You'd run a macro like this instead of updating links, after opening a workbook.