Skip to main content

Posts

Zip code Functions for VBA

Haven't posted anything to my blog in a while... so here it goes. I figured that I would contribute some of my code (albeit pretty horrible code) for those who use VBA. I personally don't care much for VBA, but I use it a lot to do some pretty neat stuff in Excel. Anyway... these VBA functions utilize Microsoft's XMLHTTP Object to get some valuable geographic/zip code information. I have provided a few VBA functions. Some of these functions are definitely hacks, as they assume that the USPS website's structure will remain the same. Although, in my opinion, since USPS.com is run by the US government, it probably won't change any time soon. :) Function GetCityState(zipcode As String) This function connects to the USPS.com website to get the city and state abbreviation for the zip code provided. Function GetZipcode(address As String, city As String, stateAbbr As String) As String This function connects the USPS.com website and tries to get the zip code, given ...
1 comment
Read more

Reasons Why 2010 is Going to be Sweet

Reasons Why 2010 is Going to be Sweet I have NO PLANS for this year -- that means I have no idea what's going to happen!  NONE!  I have nothing to lose, and everything to gain!  This is awesome! School is out for at least 8 months!  Hello, free evenings! I'm currently only working 3 days a week at GOJO!  Hello, free weekdays! Alabama is going to win another National Championship!  Yeah, I said it! I might be going to graduate school.  This means I'll at least be working toward a masters or doctorate.  One of my dreams is to be a college professor, and this would be one more step to get there! I'm going to start another business.  I'd tell you what it is, but it's secret squirrel stuff.  This time around, I'll have more time to put effort into it. I have a great family and wonderful friends to help me out!  You guys rock! There are other reasons, but... ehh... I gotta go get ready for the OSU game.  I have people coming over, and I don't want my pla...
1 comment
Read more

Wow... it's late

do { if(time_of_day >= midnight && time_of_day { int i; for(i = 0; i punch(monkeys[i]); eat(Food.BANANAS); taunt(monkeys[0]); sleep(1000); } else break; } while(true); Why would I post this code on my blog? Because I felt like it. I kind of feel sorry for monkey zero... :(
Post a Comment
Read more

Micro$oft is FAT!

Judge Kathleen Kottler-Kavein ruled that Microsoft must be broken up into two companies. The name of the two companies will be MICROS~1 and MICROS~2. HAHA!! The Bug: (not in reference to the car or the insect) So... today I stumbled upon something weird with FAT16 partitions. Why FAT16? Because the manufacturers of the SD memory card formatted the card with FAT16... your own USB flash drive might also be FAT16. Anyways... here's what happened: I had 126 files (totaling over 1.4 GB) on the SD card. If I added one more file, Windows would complain, saying that it could not create the file. And, here's the strange part... if I deleted a 4 MB file and copied a 1 MB file, it would still not let me create a new file. And, even stranger... if I deleted all of the files and created 1000 small files, it would let me. So... the problem doesn't seems to be a file size limit or a # of files limit. What is it then? WTF, mates? Here's a strange bug in FAT16: http://www.cocoa...
Post a Comment
Read more