This should be as simple as can be, but for some reason it's not working and I can't figure out why:
I have a string called LastSWApplication. I have a test like the following against it:
I've put it under testing and LastSWApplication is clearly equal to "Microsoft Office 2007 Professional", no ending spaces or the like, and the length is 34 characters.
It never matches. I backed up under testing with breakpoints and if I change the check to just before the number 2 it works fine and sets ImportantApplication to Y. The check would then look like this:
If I simply add the 2 back on both sides of the equation it doesn't match.
I have other checks like the following and they fail too:
As crazy as this sounds, it's almost as if "Microsoft Office numeric" is some special type of text. I've never had something like this in VBA but maybe I'm missing something easy. Any ideas?
Bookmarks