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 ***************************!

Array vs Arraylist Difference - C#

Introduction:

In this article i am going to explain the difference between Array and Arraylist in C#.

Arrays:

Arrays are strongly typed collection of same datatype.Generally in arrays we will store values with index basis that will start with zero. If we want to access values from arrays we need to pass index values.These arrays are of specified length that cannot be change during runtime.

Declaration:

To declare the array use "[]" brackets after data type and then assign the fixed length or fixed size to an array as shown below

static void Main()

{

    string[] myArray = new string[3];

    myArray [0] = "Welcome";

    myArray [1] = "to my";

    myArray [1] = "Blog";

}

Above code shows that we have declared a String type array size of 3 (Means we can store only 3 string values in that array).

ArrayList:

Array lists are not strongly type collection.It stores a collection of values from different data types or same data types. 
Array list size will increase or decrease dynamically it can take any size of values from any data type. These Array lists will be accessible with “System.Collections” namespace. If the values stored in collection are of different data types then type cast is must.

Declaration:

To add values to an array-list you can call "Add" method of Array-List to keep adding values continuously

static void Main()

{

    ArrayList aryList = new ArrayList();

    aryList.Add(123);                                // Added Integer value

    aryList.Add("C-Sharp");                       // Added string value

    aryList.Add(DateTime.Now);               // Added DateTime

}

Note : If the values stored in collection are of different data types then type cast is must.

For better understanding check the below table

                                     !********************* Hope you understand the difference J ***************************!

Reference:

http://www.aspdotnet-suresh.com

Send/Receive Money instantly - HDFC IMPS

What is IMPS? 

IMPS stands for Immediate Payment Service. It is an instant interbank electronic fund transfer service, which can be accessed from Mobile Banking or NetBanking. 

IMPS(from HDFC Bank) is an instant real time inter-bank electronic fund transfer service. Using this service, you will now be able to receive or send money even on Sundays and Bank Holidays or late at night.

What's more, the money is credited in to the beneficiary account instantly. So go ahead and ask your friends to send you money through IMPS and enjoy instant credits into your HDFC Bank account.

How to Receive Money using IMPS?

Using Mobile Number and MMID

     Share your MMID and Mobile number with the sender so that he/she can send money to your account instantly.

How to generate MMID.

• Generate MMID through NetBanking

• Logon to NetBanking

• Click on accounts section

• Click on Generate MMID under left panel

• Select account and confirm, MMID will be generated instantly 

                                 or

• Genrate MMID through MobileBanking

• Logon to MobileBanking App or logon to m.hdfcbank.com from mobile internet browser

• Click on accounts section

• Click on Generate MMID

How to Send Money using IMPS?

Using Mobile Number and MMID

• NetBanking

• Click on "Third Party Transfer" Tab

• Click on “IMPS Funds transfer using MMID” on the left panel.

• Fill the details ie Beneficiary Mobile Number, Beneficiary MMID, Amount , Remark and confirm

• You will receive the confirmation SMS for IMPS transaction

?.........FAQ's..........?

What happens in case I enter a wrong beneficiary mobile number when sending money using option “IMPS using MMID”?

You will have to enter both a mobile number and MMID to initiate a money transfer and funds will be credited to an account. This is another reason why this service is safe.

Is there any limit on the value of transactions when I am sending money using IMPS? 

Yes, the limits are as follows:

IMPS using MMID:

NetBanking and MobileBanking: Rs 5000 per day per Custid (on either of the channel)

What are the charges for doing IMPS transactions? 

    

If my IMPS transaction is failed or not completed, by when will I get my money back?

Yes. In case, your account is debited and beneficiary account is not credited, then please call on PhoneBanking number with the following details:

• RRN (Transaction Reference Number)
• Date of transaction
• Amount of transaction
• Remitter Bank name
• Beneficiary Bank Name

The TAT for reveral of amount for failure transaction is 5 days.

Reference : http://www.hdfcbank.com/

                          !********************* Hope this will be very useful J ***************************!

String vs StringBuilder Difference - C#

Introduction :

In this post i am going to explain the difference between String and String Builder in C#. This is a common interview question.

String

String is immutable.Immutable means once we create string object we cannot modify. Any operation like insert, replace or append happened to change string simply it will discard the old value and it will create new instance in memory to hold the new value.

Program

Using System;

public static void Main()
{
  string myString = "Difference";
  myString += " between";
  myString += " String";
  myString += " and";
  myString += " StringBuilder";
}

StringBuilder

String builder is mutable it means once we create string builder object we can perform any operation like insert, replace or append without creating new instance for every time.

Program

Using System.Text;

public static void Main()
{
  StringBuilder myString = new StringBuilder("Difference");
  myString.Append(" between")
  myString.Append(" String")
  myString.Append(" and")
  myString.Append(" StringBuilder")
}

For better understanding see the below table and image

                                   !********************* Hope you understand the difference J ***************************!

Reference:

http://www.aspdotnet-suresh.com & Venkat's csharp-video-tuotrials.blogspot.co.uk

Appear Offline Status - Lync, Office Communicator

Outline:

If you want to stop people from disturbing you when you are busy, you can appear offline in Lync/Office Communicator and u can chat with anyone in offline status in your communicator(OC-2007,Lync 2010 & 2013).

How.? 

1. Exit Lync/Office Communicator

2. Automated Solution - Download and run the reg-edit file

• Microsoft Lync 2013 users

    Download this

• Microst Lync 2010 & Office Communicator 2007 users

    Download this

3. Click yes and ok for the pop up message.

4. Once you have completed the above steps.Open your Lync/Office communicator and now you can notice a status “Appear Offline” just like Busy/Available/Away etc.

                                                                      !............... How is it?...............!

Create your first macro in Excel - VBA

Introduction :

 In this post, I will show you how to create your first macro (VBA program).

Objective :

To create a Macro which will show a Message Box "HELLO WORLD" (world classic "Hello World!" example J)

To write your 1st program and enter into world of VBA, follow the below steps

Steps :

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

2. Click on INSERT >> MODULE

3. Then in the right side window type the below Code

      

      Sub MyFirstMacro()

           Msgbox "Hello World"

      End Sub 

       

4. Then Press the F5 button to Execute(You can also click the Button)

You will see a message box saying "Hello World". You can type whatever you want to see in the message box
we should save the file in .xlsm or .xlsb file extension, so that we can run the macro later

                                        !********************* Try it out J ***************************!

Reference : Microsoft Excel Tutorials - Daily updates (Facebook page)

How to use Split Function - VBA

Introduction

Split: It is a function that can split a text string into an array, by making use of a delimiter character.

• As the name tells, the work of Split statement is to break, split or divide a string based on particular criteria.

• Split Function returns a String Array and not a String.

• Split (text_string, delimiter, limit, compare)  - where limit & Compare optional parameter

Objective

Let’s consider we have an Email ID: “someone@gmail.com” and now our objective is to break this email id into username and domain name separately.

Code: Usage of Split function

Sub Get_Domain_and_Username()

  Dim result() As String

  Dim email As String

    email = "someone@gmail.com"

    result() = Split(email, "@")

    domain = result(0)

    userName = result(1)

    MsgBox "Domain is " & domain & "UserName is " & userName

End Sub

Example 2:

Separate a list of Pipe separated names.  eg - "Yuvi|Viru|Msd|Lee"

Objective to get the third name in that list

Sub Splitdemo()
  Dim result() As String
  Dim lists As String

    lists = "Yuvi|Viru|Msd|Lee"
    result() = Split(lists, "|")

    thirdEntry = result(2)
    MsgBox "The third name in the list is: " & thirdEntry
    
    'To Loop all values in the list use the below code
    For i = LBound(result) To UBound(result)
        MsgBox "Name " & i & ": " & result(i)
    Next  
End Sub

                                   !********************* Leave your comments about the topic J ***************************!

Open and Close Workbook - VBA

Introduction

    In this post you can learn how to Open and Close a workbook using VBA in Microsoft Excel.

Objective:

    A Macro which can open and close Excel workbook.

Solution:

    Let's see a VBA code, which does it.

Simple Method:

    Macro purpose: To open & close a excel workbook

Sub OpenRCloseWorkbook()     
    On Error Resume Next
    Set wk = Workbooks.Open("C:\MyExcel.xlsx")
    
    'Error Handling If file not found
    If Err.Number = 1004 Then
        MsgBox "File Not Found", vbCritical, "Warnings"
        Err.Clear
        Exit Sub
    End If
    
    ActiveWorkbook.Close
End Sub

Tips :

If you want to close a workbook without the user being prompted about saving the workbook, use the below code

    ActiveWorkbook.Close True 'SaveChanges:=TRUE
    ActiveWorkbook.Close False 'SaveChanges:=FALSE

Dynamic Method:

    This GetOpenFilename method displays the standard open Dialog box where user can select the file.

Sub OpenRCloseWorkbook()
    Dim MyFile As String

    MyFile = Application.GetOpenFilename()
    Workbooks.Open MyFile

    Filename = ActiveWorkbook.Name
    Workbooks(Filename).Close True
End Sub

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

Delete Files and Folders - VBA

In this blog you will learn how to:

• Delete a file
• Delete all the files in a folder
• Delete/Create a directory using VBA 

Please note that Kill command permanently deletes the file. we cant "undo" the delete.

'Macro Purpose: To Create/Remove a folder

Sub Create_RemoveDirectory()

    On Error Resume Next

    Kill "C:\Test\*"          ' Deletes all the files in the folder Test

    RmDir "C:\Test\"       ' Deletes empty folder

    MkDir "C:\Test"         ' Creates a Folder name Test

    On Error GoTo 0

End Sub

'Macro Purpose : Deletes given file & deletes all *.TXT files in current directory.

Sub DeleteFile()

    On Error Resume Next

    Kill ("C:\Test1.xlsx")

    Kill ("C:\Test\*.txt")

    On Error GoTo 0

End Sub

Execute the code step by step for better understanding

Sub SampleProcedure()

    Dim fpath As String, ffile As String

    fpath = "C:\Test\"

    ffile = Dir(fpath + "*.txt")

    

    Do While ffile <> ""

        Kill (fpath & ffile)

        ffile = Dir

    Loop        

    MsgBox "Files deleted in the given folder"

End Sub

                                                Hope this would help beginners J