vb.net - Excel VBA socket connection -
I have used Google to try to find a solution to my problem but no solution can be found.
I have a VB.NET
application that successfully sends a string to the specified IP address and port using this code.
On this remote computer, I can get this string and do I want to use it by using VB.NET
, but I excel. Of
public sub BroadcastData (ByVal need to be provided as a string toSend, use dim s as ByVal PortToSendTo) new socket (AddressFamily.InterNetwork, SocketType.Dgram, ProtocolType.Udp) dim sendBUF byte as () = Encoding.ASCII.GetBytes (toSend) dim EP New IPEndPoint (MainForm.IPToBroadcastTo, PortToSendTo) as s.SendTo (sendBUF, as the EP) System.Diagnostics.Debug.WriteLine (s.SendTo ( SendBUF, EP) End Sub
Where is the IPaddress of a remote computer on IPToBroadcstTo
Local Network.
I should calculate R to get the string, in Excel, to take the string and write it to a cell, then calculate with it.
The code you posted is VB.NET's Excel uses VBA, though it is something normal The syntax shares, however, there is a completely different language with less set of libraries.
For example a class in socket
or IPEndPoint
VBA.
The answer in a nutshell is that you can '
Take a look at the control or
Maybe you can write a NAT assembly Use it to use in Excel.
Comments
Post a Comment