Wed 19 Mar 2008
Using VBA feels like going back to the stone age.
I had to write a custom function in Excel for work. So I had to use Visual Basic for Applications. Using that language feels like the going back to the stone age after getting pretty familiar with PHP. I kept thinking “I could do this in five minutes in PHP.” You have to worry about type casting, or rather type conversion, constantly. I had CStr and CDbl everywhere. And you can’t easily do a dictionary array. And it was the lack of sensible type conversion that did me in. My function kept complaining about incorrect types. I ended up finally finding code for what I needed to do online. I didn’t see any obvious differences that would have caused the error. So be glad for PHP being as good as it is.

Sorry, comments for this entry are closed at this time.