Jun 19
Just yesterday I wanted to check added/deleted files from hundreds of files in two directories. In the most rude manner I could have taken snap shot of two directories and printed it for manual checking.
But that option was ruled as they were enough to keep busy whole day. So the next thought, what if I could somehow list the files of all directories? Won’t it be easy to list the files in excel sheet and use vlookup to find the missing/new files?
But How do I list the files? I know there are hunderds of freewares on net which will help you to that and hunderds of scripts guiding you to design your own software.
I found the simplest and the most effective solution using DOS.
2 commands and the list is ready for you!
1. Go to Start button> Run
2. Type cmd & press Enter
3. Now, using ‘cd’ command go to the directory which you want to list.
4. Once you are in the dirrectory us following command to create the listing:
dir /b > list.csv
Tada! The list is created in the same directory. Now you can one the file in excel and save it as a .xls file for further use. No software, no installations. A clean, simple way!
That’s for the day!
nJoy.
Apr 19
Ever caught in a situlation where your boss is looking at your screen and your friend pops you up on gtalk with all sorta “friendly” talk? I was once….
boss : Wow! that’s great! Now they have put the pictures on sametime? (Sametime is IBM’s chat msngr)
me: err…yeh… kinda… jus for testin…
boss: oh really? they should keep it!
me: oh yeh…. (hushhh….thank god!)
and then I thought, I need to do something to get rid of this problem..
n here is d solution…. Gtalk Shell.. a damn cool gtalk plugin.
Just install it and Done!
Instead of opening gtalk, open Gtalk Shell.
When’s your boss is around, just press Ctrl+Alt+Q. All gtalk windows will be hidden instantaneously. Press it again.. they’ll reappear!
you can explore more feature like anti-boss etc in the shell menu.
Just google “gtalk shell”.. you’ll find the downloading link..
nJoy.. Happy Chatting! (in office hours 
)
Nov 28
Ever tried to find the uppercase button in Microsoft Excel or tried to strike through text in the cell?
Yes! You will end up with a big surprise that there are no such one-click buttons available in MS Excel. So what will you do to change all uppercase letters from a row to Sentence case?
Difficult? Not really! Here is a 2 step solution to add these MISSED features:
- Download : Personal.xlsb
- Copy the downloaded file to following location : C:\Documents and Settings\<your-username>\Application Data\Microsoft\Excel\XLSTART
So How does this benefits you?
This Excel Binary File contains macros for following operations:
- Toggle Uppercase (Ctrl+u)
- Toggle Lowercase (Ctrl+l)
- Toggle Sentence Case (Ctrl+Shift+s)
- Toggle Strike Through (Ctrl+k)
- Toggle Superscript
- Toggle Subscript
Impressive? Aha! You can add all you want with macros.
So learn to look at the Macro level 
Note:
1. Please make sure macros are enabled.
2. All those who want to look what exactly goes behind the screen, goto MS Excel VB Editor and have a look at the code.
Nov 19
If you ever face a problem where in all application (.exe) files (e.g. notepad.exe) are not opening, you can try renaming them to “.com” (e.g. notepad.com) . It might work for you perfectly till you resolve the problem.
This is extremely effective when your system is infected with virus which is not allowing you to execute .exe files and you want to access windows system applications like msconfig, regedit or even command prompt (cmd).
Oct 01
Ever wondered how to open a file, associated with a program, in other program? Ever Struggled to open a zip file (associated with WinZip) in WinRar? Ever wondered how to open an avi/mpg/dat file in VLC Player or KM Player, without associating them with that player? (yeh yeh.. I know.. the ‘Open With…’ wala funda)
If yes, please continue reading! (Others can read it as well… off course if you have couple of minutes to spare 
)
Its just 4 step process :
1. Create a shortcut of the application. (e.g. Notepad, WinRar, VLC, KM Player, Irfanview or whatever)
2. Goto “Run” (Start Button – > Run)
3. Type “Sendto” and press Enter (A folder will open)
4. Copy the Shortcut in that folder
Its done.. now you can use these softwares any time with two mouse clicks only.
Just right click on the file, select “sendto” menu and select the program in which you want to open the file.
