新聞財經娛樂♬資訊 News Economy

Using some vb code to extract some information out of a website
Occasionally the website goes down, and presents a 504 error page.

The element I'm trying to extract is not present on the 504 page.
How can I edit my code so it only extracts the information if it actually exists?

Thanks in advance

Set TDelements = HTMLdoc.getElementById("menu_content").getElementsByTagName("TD")                                  

1:

Probably you want it on VBA on Excel, Right ? if so, test following code
to check object ID first before any info extraction

set  obj= HTMLdoc.getElementById("menu_content")If obj Is Nothing Thendebug.print "obj not exist"Elsedebug.print "obj exist"End If                                          

1:2:3:4:5:6:7: