Hi,

I am trying to write the contents of a dynamic website (I guess it's PHP or something similar) into a worksheet
I attempted to open as text stream the URL of the website, but the previous step of getFile does not work

any other way around to achieve what I am trying to do?

excel2003 by the way


'2013-10-25 / B.Agullo /
Public Sub checkDANs()
'description here
    
    Dim webSt As String
    
    webSt = GetBoiler("http://*******/DAN?OpenView")
    
End Sub
and Getboiler I got somewhere

Function GetBoiler(ByVal sFile As String) As String
'**** Kusleika http://www.rondebruin.nl/mail/folder3/signature.htm
    Dim FSO As Object
    Dim TS As Object
    Set FSO = CreateObject("Scripting.FileSystemObject")
    Set TS = FSO.GetFile(sFile).OpenAsTextStream(1, -2)
    GetBoiler = TS.ReadAll
    TS.Close
End Function
thank you!