#Winsock excel vba tutorial how to#

We can calculate the length of a string by using the function Len This work will enable you to reap WinSocks benefits to create client and server network applications.

The replace function will replace the word 'Sam' in the string text1 by the word 'Ron'Д¬alculating length of string and reverse of string Windows Sockets (WinSock), a standard network API co-developed by PC network industry leaders including Microsoft, Novell, Hewlett-Packard, and FTP Software, is a resource for Windows network programmers. It can be done by using the function 'Replace' as shown below: It gives the starting position of the substring 'Sam' in the main string 'Sam is my name', but the only difference is it will start searching the string from the end. Msgbox InStrRev ('Sam is my name', 'Sam'): Result: 1 It gives the starting position of the substring 'Sam' in the main string 'Sam is my name', Msgbox InStr('Sam is my name', 'Sam'): Result: 1 Mid: Mid('Sam is my name', 1, 3) result is Mid 3 chars starting position is 1: 'Sam'.Right: Right('Sam is my name', 4) result is left 3 chars: 'name'.We can also do it like: AppendedString = 'My name is: ' & 'Sam' which will give the same result. So the AppendedString will result in: 'My name is: Sam' We can append the strings in VBA using & char as shown below: Calculating length of string and reverse of string.We will try to learn the following string operations/uses cases: String can be any text or a combination of text and numbers etc. In this article, we will learn to do string operations using Excel VBA.

#Winsock excel vba tutorial how to#

How to Manipulate Strings in Excel Vba Details