Airtel service messages

Hi everyone,
Today I came with Airtel service messages, which can be used by post-paid customers.

1.      To start ebill SMS:             STOP PAPER  <(email id)> to 121
2.      To Update your email id SMS:            UPDATE EMAIL <(email id)> to 121
3.      View last 6 months ebills by simply sending SMS:
             EBILL <(email id)> <(first 3 letters of the month)> to 121
4.      To get your ebill password SMS:         EBILL PASSWORD to 121
5.      To stop ebill SMS:              STOP EBILL to 121

Hope it will be useful.

Vodafone Services Messages which saves lot of things for us

Hi everyone,

Please pay attention, if you have a vodafone post-paid connection.

Please do this things, once you get a new post-paid connection.

Send these below messages to 111 and save lot of things.

1. Get Bills to your e-mail address: ACT LIFEGREEN to 111 (Save Trees)
2. CAN VL to 111 (De-Activate data plan which is defaultly activated by vodafone, Save Money)
3. BILL to 111(Get the Un-Billed Amount, Save Calls)

Do update your account properly, fill the details and choose the corresponding services in vodafone.

File copying based on cell value to different directories on some condition

File copying based on cell value to different directories on some condition


Description:
I have lot files to copy into two different directories. I sorted those file names in a such a way that odd row numbered file should go to the directory named "Odd" and even row numbered file should go to the directory named "Even".

I am checking whether the file exists or not in the particular directory before copying. If exists it will ask the user for confirmation and stored with suffix1.

References:
http://msdn.microsoft.com/en-us/library/cahdzfxw%28v=vs.80%29.aspx
http://www.techotopia.com/index.php/Working_with_Directories_in_Visual_Basic
http://www.mvps.org/dmcritchie/excel/strings.htm

Adjust the audio/video delay(Sync) in VLC Player

Hi all,
When I was watching the movie, I got fed up with the delay between audio and video. There is not synchronization between the voice and the scene, which is going on. So, I just got the some information to share.

In VLC Player,

Select Tools-->Effects and Filters-->Select Synchronization Tab

Keyboard Shortcuts:
Use "k" to audio delay up and "j" to audio delay down.
Use "h" to sub-title delay up and "g" to sub-title delay down.

Try these shortcuts and watch the movie happily without problem.
Send your feedback and comments.

Create a custom theme in Windows 7

Hi everyone,
If you are bored with the themes in your windows 7 .. Just create a custom theme with your own photos and icons etc.

You can create or select your own cursors, sounds, visual styles in customized theme.

Just some patience is enough to do all ..
Lets do it !!

The Theme File Format : http://msdn.microsoft.com/en-us/library/bb773190(VS.85).aspx
Send me your customized theme to me also .. :)

Google Account 2-Step Authentication Setup

Setup

Make your Windows 7 Laptop as Wi-Fi Hotspot using Connectify

Hi everyone,

Do you want to use your laptop as a Wi-Fi hotspot? Want to share your laptop Internet on you mobile to reduce the 2G/3G charge?

It is possible with Connectify Hotspot.

When we have one laptop with wired Internet connection, we can make that laptop as a Wi-Fi hotspot.
So that, we can connect our mobile or iPod or other laptops to the Wi-Fi hotspot to get Internet.

There are lot of methods or procedures to do that. But, I tried the following and its very good.

Here is the procedure

1. Download Connectify and install.
2. Then just give the name and password to create a Wi-Fi hotspot.
3. Any other device with the password can connect to the particular Wi-Fi hotspot. 

Try and let me know, if any other easy steps to create a Wi-Fi hotspot exists.

References:
http://www.connectify.me/