TheSwamp

Code Red => VB(A) => Topic started by: Andrea on July 09, 2004, 04:42:00 PM

Title: STRING SEARCH
Post by: Andrea on July 09, 2004, 04:42:00 PM

Hi all...

How to get string from another string in VBA ?

ex: i have this "allo" and i need this "al"

thanks

Title: STRING SEARCH
Post by: MP on July 09, 2004, 04:44:12 PM

Look up functions INSTR  (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctInStr.asp) and MID$ (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctMid.asp) in the help; plenty of examples abound. :)