Macro assistance w/changing URL date link

[stangz71]

I have a macro that will go out to a website and search for a serial number. Once it finds the serial number, it will click on a link with a date on it. Once it opens up the new window, it copies all of the data and sends it back to Excel. The problem is that the date changes each day and cannot get the macro to click on the updated date link, any ideas?

[shg]

Post your code that works for a particular date.

[stangz71]

I had to change the serial number information and changed the website to test.com because it is an internal website, otherwise, everything else is the same. The issue is the "asupid=86857319" that changes each day but it shows up as a date you can click. If there is a way to click the new date each day and bypass the ID, that would also fix the issue. Any help would be appreciated, thanks.
============================================================================

Sub Serial_ASUP_Information()
'
' Serial_ASUP_Information Macro
'

'
Cells.Select
Selection.QueryTable.Delete
Selection.ClearContents
Sheets("2Fxxxxxxxx").Select
Sheets("2Fxxxxxxxx").Name = "2Fxxxxxxxx"
Range("A1").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;https://test.com/AssetDashboard/asups/showAsup?asupid=86857319" _
, Destination:=Range("$A$1"))
.Name = "showAsup?asupid=86857319"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub

[shg]

"asupid=86857319"

How is the date embedded in that?

[stangz71]

2014-07-28_21-12-29.jpg

Attached is an image on the information I have on the connection between the link and the ID. The ASUP ID comes up when I hover my mouse cursor over the date.

[shg]

Can you explain that in sentences?

[stangz71]

I found out today that the number is random so I cannot correlate the ASUP ID and the date. Unless you have a trick up your sleeves, it's not going to be possible.

[shg]

Nope, no tricks here.