View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francesco Sblendorio Francesco Sblendorio is offline
external usenet poster
 
Posts: 12
Default "Not" and "Not Like"

If WSh.Name < "Admin" and < "Server * Projection Seed Values"

First of all, this line lacks 'WSh.Name' before '< "Server *... '
Obviously this test will not perform a LIKE compare.
To solve your problem, you can do so:

If WSh.Name < "Admin" and Left(WShName, 7) < "Server " and Right(WShName,
23) < " Projection Seed Values" Then

Be attention: "Server " ends with a space, " Projection Seed Values" begins
with a space.