VBA icon

Determine local system32 folder

Something from the FAQ which probably doesn't belong there:

Continue Reading: Determine local system32 folder »

VBA icon

Len vs Empty, which is faster

In Is That String Really Empty? I mentioned that Empty returns the same response as Len when checking variable- and fixed-length strings. Let's test which one is faster.

Continue Reading: Len vs Empty, which is faster »

PHP iconVBA icon

Annoying Website Name Generator in VBA and PHP

I don't know about you, but when I see a website name cashing in on the latest social media trend, I shake my head.

Continue Reading: Annoying Website Name Generator in VBA and PHP »

VBA icon

Is That String Really Empty?

ball of string

While testing out some operations on a Variant, I ran across an interesting problem. One of the variables I used was a fixed-length string.

Turns out, this type of variable fails the Len test: it returns the predetermined length of the variable even if you don't set it to any value! I recognize, however, that this may be only a minor problem. Who uses fixed-length string variables that often anyway?

Continue Reading: Is That String Really Empty? »

VBA icon

Len or LenB, which is faster?

Hope you had a fun New Year holiday!

Continuing with the series of tests I've been posting, another function I found is LenB. I don't know much about it, but it supposedly returns the length of a string, the same as Len.

Continue Reading: Len or LenB, which is faster? »

Site last updated: February 9, 2012