How to Use WinHttpRequest (WinHTTP Services) in Excel VBA to Stream Data from Websocket Server

Asked Apr 03 '20 at 20:53

Active Apr 03 '20 at 20:54

Viewed 1,252 times

I would like to stream data from a websocket server using VBA in an Excel workbook.

This is the actual data stream I would like to receive and process in VBA:

Would you recommend using WinHttpRequest (WinHTTP Services) or any other service to connect and receive the websocket data?

From the Microsoft documentation it is not clear to me if WinHttpRequest supports the websocket protcol and unfortunately no examples are presented.

edited Apr 03 '20 at 20:54

braX

asked Apr 03 '20 at 20:53

AlexR

WinHttp.WinHttpRequest.5.1 ActiveX doesn't expose such methods allowing to work with websockets. May be that is possible via direct calls to Winhttp.dll. – omegastripes Apr 04 '20 at 00:24

0 Answers0