I have VB program that works in Studio 2005.
When I copied same program to Excel, there is compilation error.
Here is a program:
1. Imports System.Net.Sockets
2. Imports System.Text
3. Function Client(Request As String)
4. Dim tcpClient As New System.Net.Sockets.TcpClient()
5. tcpClient.Connect("127.0.0.1", 8000)
6. Dim networkStream As NetworkStream = tcpClient.GetStream()
7. Dim sendBytes As [Byte]() = Encoding.ASCII.GetBytes(Request)
Lines 4-7 fail with error "Compile Error, Expected end of statement".
Is it possible to use System.Net.Sockets inside Excel function?
If so, what is syntax?
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
