VB6 Deco

As the month of April is approaching, we are getting ready to get rid of VB6. Microsoft has announced that on 8th of April, they will be decommissioning VB6. That means no more microsoft certified support groups, no more hotfixes. Finally they are officially getting rid of something archaic.

We, in office are totally geared up in decommissioning the VB6 based apps. We started the whole getting rid of TFA a while back. That had nothing to do with VB6 deco. OMS deco in Asia was the main reason for doing that. It being a VB6 app is just going to fasten the process now. Anyways, we are almost there now. And we have taken PFA in the umbrella too. So more so, a reason to celebrate.

Actually, I am not very well verse with VB6/macros. I have never really done it. People say with macros you can do more than timepass programming. But I never got such a use case to apply my knowledge of macros, until today. Today there was a randomly color coded list of users in excel and I wanted to sort it colorwise. Now excel does not support sort by format menu. So I was supposed to write a macro to do that. But my limited VB scripting knowledge was a hindrance to that. I was actually contemplating about sorting the list of 150 odd users manually, which actually wouldn't have been such a big deal. A little donkey work..yea... but better than spending a lot of time figuring out 'M' of macro. Finally my manager wrote it to make it easier for me. I have to say he is a really good manager.