Automation using Excel macros is finding its deserving position amongst many businesses. This article talks about the benefits that automation using Excel macros brings to a business.

---

Excel macros have proved over the last few years that technology driven automation of regular and repetitive works can reduce the turnaround time, increase productivity and will always ensure better quality and hence, benefit business.

In reporting and analysis sector, we come across huge data that has to be processed, analyzed and employed daily to get analysis and reports that impact our business. There exist huge amount of repetitive work that is also time taking, prone to manual errors and in terms of quality are nothing but a waste or Muda. Automation of these reports can complete the entire process quickly and hence, can easily reduce the turnaround time. Excel macros are the perfect automation tools that we can get in a reporting and analysis environment. They can help us not only in getting the process done quickly, but also can eradicate human errors. With zero human errors we do not waste time on re-work and hence, a lot of direct and indirect resources are saved. This has a direct impact on our business.

Excel macros show us how technology benefits business. This technology has changed the way one used to look at raw data that has to be analyzed and converted into useful business information. Loads of data can now be processed within minutes using Excel macros and the analysis becomes easier, with zero error and better quality data. These macros can be run from any machine and by anyone and a business utilizing this technology can reduce the overall headcount too. Automation using Excel macros can do the job otherwise manually done by many employees, with a quality output, zero errors and within a faster turnaround time. When the cycle time is reduced and you do not need to worry about doing a re-work on the project, you can rest assured that this will technology will benefit the business in both monetary terms and in gathering better customer satisfaction.

Hello!

I am here again today with another introductory post. Hope you are enjoying the series and using the information shared here. Today, I will introduce Macro for Microsoft Office Outlook. This is interesting, as we would all like someone to check our daily emails, put those emails into different folders, sort them on our requirements and probably compose and email a reply to the sender with the adequate information. Yes, all these are possible in Outlook itself and whatever is not already present, can be achieved using a bit of VBA coding or using Macros. Macros in Outlook are fascinating and today I will show you a simple macro which will tell you when an email lands up in your mailbox.

Open Outlook and Hit Alt + F11 to open the VBA Editor. This is what you do to open the editor in any Microsoft Office Application. Once in the editor, add a new module and type in this text below:



Sub MsgAlert(NewMail As Outlook.MailItem)
MsgBox "You have got a Mail."
& vbCr & "Subject: " & NewMail.Subject & vbCr & "From: "
& NewMail.SenderName & vbCr & vbCr & "It Says:- " & vbCr
& NewMail.Body, vbInformation, "Attention!"
End Sub


This will tell you with a message box telling about the new email that has landed in your inbox with fields like, Subject, Sender Name and the Content of the email. Now, you may add a rule to call this Macro or just modify an existing rule to incorporate this script. To know about Rules and Alerts in Outlook, visit this link.

Macros in Outlook can also be used to automate any task that you perform over and over again. Like sending an End of Day Report Notification or may be responding to specific email lists etc.

To know more about Codes in outlook, you may also visit this exciting website:

http://www.outlookcode.com/

Do let me know how it went. Till then, cya!

Hi Folks!

There are two new things that I learnt while coding in VBA today and I thought of sharing the same with you!

Ever wanted to open a directory or folder somewhere in the computer from within the code you write? Well, some you might have wondered how to do that; and to others, who have not tried it, it would sound rather interesting. Here is one way that you can do this. To open a folder called Code present in your C Drive, you can use the following code:

Sub OpenDir()
Call Shell("Explorer C:\Code, vbNormalNoFocus)
End

Yea, that is all it is! Simple, right? I felt so, after some good time spent on it.

Here is the next one. We all use Alt + F4 to close a file, a folder, Windows Sessions or even the application that we are working on. How to do that from within your script? Well, here we are trying to replicate the key press combination: Alt + F4; and not just a close syntax. Heard of the command SendKeys? Here is one way to do that:

Sub PressKey()
SendKeys "%{F4}"
End

Or if you want a question before you close:

Sub PressKey()
Dim iX As Integer
iX = MsgBox("Close?", vbQuestion)
If iX = vbOK Then
SendKeys "%{F4}"
End If
End

Hmmm. I found it interesting! Go ahead and try different things with SendKeys and I am sure you will discover something more, for sure. Also, let us know if you have some specific queries related to the above two commands. We will try to dig into it. Keep coding – keep learning and do not forget to share what you have got.

Let us learn and grow together!