Open a txt file

[jnevada]

I need to open a txt file by clicking on the excel logo below on a website. Is it possible for excel vba to accomplish?



Thanks in advance for your help.

[ranman256]

VBA can open a text file, but what does your question mean? click a logo on the spreadsheet?????

[jnevada]

VBA can open a text file, but what does your question mean? click a logo on the spreadsheet?????

The logo is on a website. Thanks for your response

[ranman256]

I get my text from website using :

Function ExecuteWebRequest(ByVal url As String) As String
Dim oXHTTP As Object
If InStr(1, url, "?", 1) <> 0 Then
    url = url & "&cb=" & Timer() * 100
Else
    url = url & "?cb=" & Timer() * 100
End If
Set oXHTTP = CreateObject("MSXML2.XMLHTTP")
oXHTTP.Open "GET", url, False
oXHTTP.send
ExecuteWebRequest = oXHTTP.responseText
Set oXHTTP = Nothing
End Function