Thread: searching through a string?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
  
Posts: 258
Default searching through a string?
Hi,

combine mid and worksheetfunction.find

supposing directory is a string that contains the path, outstring is
result:

outstring = mid(directory,worksheetfunction.Find
("_",directory)+1,worksheetfunction.Find ("
",directory,worksheetfunction.Find
("_",directory))-worksheetfunction.Find ("_",directory)-1)

Regards,
Ivan

Reply With QuoteReply With Quote