Summary: App to communicate between Excel spreadsheets running on different machines to C# server running on one machine.
There is one to many relationship(one server(c#) <-> many client(Excel).
Gap: currently the program is written to communicate one way only. Currently, the application supports sending string messages from Server to all the clients.
current technology stack
client:
excel vba
uses [login to view URL] component.
server:
written in c#
uses C# sockets.
Required enhancements:
1 - Client(Excel) should be able to send the String message to the server.
2 - Server should be able to read the string message and then depending on the condition, it should route the message to the particular set of excel clients that are already connected.