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