Hello folks,
I am looking for a way to receive strings (measured values) from an ESP32 via WiFi using VBA and write them in a table in descending order.
As a naive beginner, that's how I imagine it ...
The values are transmitted every second from an ESP32 via WiFi via TCP (e.g. on port 2000).
The Arduino side is not the topic here
The ESP32 should connect to the hotspot of my laptop, set up a TCP server and show its IP and port in the display.
Then I open the corresponding XLSM on the laptop and start a UserForm where I can enter the IP and the port and connect to the ESP32 using the "Connect" button.
Then there is a start and a stop button to start and stop "listening".
Then every incoming message, which consists of a generated MsgID and the measured value, should be entered in the next line.
I've looked at all sorts of examples, but somehow I'm not able to apply it to my case.
I saw a video on Youtube that apparently does pretty much what I'm looking for.
However, without specifying any further information or code ...
Unfortunately, the uploader does not respond to inquiries either.
I hope someone here can guide me to the solution.
LG Robert
I am looking for a way to receive strings (measured values) from an ESP32 via WiFi using VBA and write them in a table in descending order.
As a naive beginner, that's how I imagine it ...
The values are transmitted every second from an ESP32 via WiFi via TCP (e.g. on port 2000).
The Arduino side is not the topic here
The ESP32 should connect to the hotspot of my laptop, set up a TCP server and show its IP and port in the display.
Then I open the corresponding XLSM on the laptop and start a UserForm where I can enter the IP and the port and connect to the ESP32 using the "Connect" button.
Then there is a start and a stop button to start and stop "listening".
Then every incoming message, which consists of a generated MsgID and the measured value, should be entered in the next line.
I've looked at all sorts of examples, but somehow I'm not able to apply it to my case.
I saw a video on Youtube that apparently does pretty much what I'm looking for.
However, without specifying any further information or code ...
Unfortunately, the uploader does not respond to inquiries either.
I hope someone here can guide me to the solution.
LG Robert
