Check Bank Account balance through Miss Call and SMS

Missed Call Service to know Account Balance

Apart from ATM and Internet Banking, You can check your Bank Account Balance through Miss call and SMS. It also worked for sundays

Some Banks introduced missed call service for customers which allows to retrieve bank account details, Mini statement etc. by simply giving missed call to their toll free numbers.

How it works

Give two ring missed call on the toll number provided.

On receiving a missed call from a registered phone number, the underlying App performs a phone number lookup and sends the data to the caller via text message(SMS).

The only thing is that you must register your mobile for SMS alert or mobile banking

HDFC BANK: Following services are now available

• 1800 270 3333 - Account Balance

• 1800 270 3355 - Mini Statement

• 1800 270 3366 - Request for new Cheque Book

• 1800 270 3377 - Request for Bank account statement

OTHER BANKS Providing Missed call service 

Note: SBI (India's Largest Public sector bank) has not yet started missed call service.

                             !*********************  Give two rings  J ***************************!

Remove the 'Recent Places' icon from desktop :: Windows 7

Problem Statement:

• The Recent Places icon belongs in Favorites but can sometimes accidentally be moved out to desktop, creating an odd and frustrating link.

• you can't delete it by right clicking on it or drag it to the recycling bin! 

• To solve the problem , Follow the below steps

Solution:

1.  Open "Computer" and drag "Recent places" to your Favorites in the sidebar

2.  And then don't forget to refresh your desktop

                                  !********************* It Works J ***************************!

Find Function in Excel - VBA

Introduction

• Find is a very powerful option in Excel and is very useful. 

• This post describes Find Function in Excel - VBA

• Objective is to Find a String or Value in Excel Workbook/Worksheet

VBA - Function

• The below function finds the given string and returns the row number. 

• If you want the cell address to be return by the function, then use the below line of code  

          find = ActiveCell.Address

Function find(ByRef findString As String) As Integer   

    Dim Rng As Range

    ActiveSheet.Range("A1").Select

    With ActiveWorkbook.ActiveSheet.Range("A:B")

        Set Rng = .find(What:=findString, LookIn:=xlValues)

        If Not Rng Is Nothing Then

          Application.Goto Rng, True

          find = ActiveCell.Row

        Else

          find = 0
          MsgBox "Search String Not Found"

        End If

    End With

End Function

And here's how you call it in your Program:

Public Sub callingProgram()

    Dim rowNumber As Integer
    rowNumber = find("Allwyn")
 
End Sub

                                       !********************* Find it.? J ***************************!

Download - Advance Tab

Installation steps :

Note: Please close all the opened excel files before install.

Step1: Click Me to Download  ( Supported Versions: 2007 - 2013 )

Step 2: Extract the downloaded zip file & Run the setup file in it.

Step 3: After installation - Open Excel, Now Advance Tab menu will appears as shown below

Check Features and Demo Video

                                     !********************* Let me know how it works ***************************!

Send an Email from Excel - VBA

Introduction:

Excel VBA allows us to send emails from Excel. In this article i am going to explain about this.

We can use a VBA macro to create/send a new message and preset any of the fields, including To/CC/BCC, the subject, flags, voting options and more.

Steps:

1. Open Excel, and press Alt+F11 (this will open a new window Visual Basic Editor)

2. Select Tool option in the main menubar >> and then select References

3. Select Microsoft Outlook 14.0 Object Library or higher version reference

4. Click on Insert >> Module and then paste the below code

Code:

Sub Sendmail()

    Dim olApp As Outlook.Application

    Dim olMail As Outlook.MailItem

    

    Set olApp = CreateObject("Outlook.Application")

    Set olMail = olApp.CreateItem(olMailItem)

    

    With olMail

        .To = "xyz@abc.com"

        .CC = "wxy@abc.com"

        .Subject = "Automated email from Excel"

        .Body = "Hi, This is test Email"

        .Display

        '.Send

    End With

    

    Set olApp = Nothing

    Set olMail = Nothing

End Sub

You can change .Display to .Send if you want to send mail automatically (Use .Display when testing)

To add attachments in the mail. use the below line of code

                                                 !********************* Try this J ***************************!