Rupesh Mehta

Name:
Location: Bangalore, Karnataka, India

Sunday, May 25, 2008

Sending an email from Microsoft excel-sheet based on certain cell condition

1. Open excelsheet.
2. a) Go to Tools->Macro->Visual Basic Editor (or Type Alt-F11)
b) In Visual Basic Editor, go to Tools->References and check (select) "Microsoft Outlook 11.0 Library"
3. Find out "Microsoft Excel Objects" in left panel
4. Double-click on the sheet you want to set an alert for.
5. Lets say you want to set an alert for cell E7 if value is less than 0, use below code.

Private Sub Worksheet_Calculate()
'from within any vba module, choose Tools, References,
'and make sure the Microsoft Outlook x.x Object Library
'is checked
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
If Range("e7") < 0 Then
Set objOutlook = CreateObject("outlook.application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
With objOutlookMsg
.Subject = "Alert from Excel"
.Body = "Cell E7 is less than 0"
.To = "yourID@yahoo.com"
.Send
End With
objOutlook.Quit
End If
End Sub

6. Also, you may need to go to Tools->Macro->Security and set security level to "low" to test it if it doesnt work out with "high" security level.
Hope this will work out.

Wednesday, May 07, 2008

Flickr Vs Picasa

Here is an article comparing Flickr and Picasa, and the winner is "Flickr".
http://labnol.blogspot.com/2006/12/picasa-web-albums-vs-flickr-which.html

Also, note that there are some tools available for downloading pictures from Flickr. Downloadr is the tool for Windows only, Size: ~300kb zip. Below is an article about the same.
http://labnol.blogspot.com/2007/04/download-multiple-flickr-pictures-in.html

Wednesday, July 26, 2006

Google Vs Yahoo: A case of different strokes


Nice article about
Goog Vs Yahoo!

[Blogbot] Generating graphical novels based on text from web blogs

Its cool.
http://www.sq.ro/blogbot.php

Blogbot is a software agent in development that generates experimental graphic novels based on text harvested from web blogs.
Blogbot crawls the web and takes snapshots of web blogs related to a user-specified theme. Then, based on the harvested text, a dynamic collage of images and strings is generated using a keyword-matching algorithm. Later versions will use computational linguistics approaches to derive meaning from text.

Project Demo : http://www.sq.ro/blogbot
List of other sq.ro projects: http://www.sq.ro/projects.php

Monday, June 26, 2006

Rich Dad Poor Dad - Robert Kiyosaki

This is the book each person should go through. It is a book talking about importance and basics of financial education and what Rich Dad teach their children which poor dad fails to teach. Things are made pretty clear and simpler with the help of figures and explaination. I'm sure this will give (financial earning) direction to you. In schools, we don't get financial education but we do concentrate only on acads to get good rank with the false assumption that best performance helps to achieve better job, etc. Two simple fundas explained in RDPD are:
  • Liability VS Asset
  • Earnings: Employer/Businessman VS Employee
Very simple to understand definition of Liability and Asset is: 'Liability' takes money out of your pocket (things fall under this category are: credit card, bank loans, etc) whereas, 'Asset' puts money into your pocket (things fall under this category are: stocks, mutual funds, real estate,etc).

The financial cycle of a Businessman/employer:
  • Earn
  • Spend/Expenses
  • Pay tax on left earnings
Whereas, financial cycle for an employee:
  • Earn
  • Pay Tax of earnings
  • Spend left amount
"Income Tax" was brought into picture to take money out of rich people's pocket,but real picture depicts that it took money out of only middle-class people's pocket.

I would rate this book as 9/10.

Wednesday, April 26, 2006

My Book List

I'm found of reading short (story) books. Here is the list of books, I read till now. [Although, its very small at present, I would like to add many more to its list.]
  • English
    • Five Point Someone - Chetan Bhagat
    • A Night at Call Center - Chetan Bhagat
    • Wise or Otherwise - Sudha Murthy
    • Wings of the Fire - Abdul Kalaam (incomplete)
    • You Can Win - Shiv Khera (incomplete)
    • Rich Dad, Poor Dad - Robert Kiyosaki
    • One Up on Wall Street - Peter Lynch (in progress)
  • Marathi
    • Tirip - Ramchandra Jorwar
    • Wise or Otherwise - Sudha Murthy
    • and few more which I dont remember.
I'll share my opinion about each of the book, soon.

Monday, April 24, 2006

Quote of The Day

  • Albert Einstein - "It's not that I'm so smart, it's just that I stay with problems longer"
  • "In matters of style, swim with the current; in matters of principal, stand like a rock"
  • "Peace is its own reward"
  • "Asset keeps money into your pocket, whereas liability brings money out of your pocket"
  • "A fool and money is a big party"
  • "A recent police study found that you're much more likely to get shot by a fat cop if you run"

Saturday, March 18, 2006

Social Impact of Software Industry

Currently, I'm re-reading a book, "Wise or Otherwise" written by Sudha Murthy, a head of Infosys Foundation. The book tells about SM's social/personal life experience. Its full of short stories where she had put all her good/bad experiences. Although stories are short ones, the messages they carries are really worth following.
One of the story includes "Social impact of Software industry". The scene was naratted around two marriage brokers discussing Software industry impact on marriage. Most of ppl from software profession choose their life partner to be in the same profession, which in turn is a good thing. Software engg. gets prestigious look as they fly abroad, gets lots of $$$. But, this has lead to many problematic situations. Nowadays, girl wants to marry a person from software profession, other professioners (mech engg, civil enggs, doctors, etc) are not getting prestigeous look, as their profession doesn't carry a chance for them to fly abroad, as they dont get good salary compared software ppl. Parent of software professionals asks for more dowry as a guy is software engg and has been flying abroad, many times.
Current rate in A.P. is around a crore for an MTech CSE guy. Simply ridiculous...!!!!
Does being other professioner a sign of less talent, a sign of useless work ? No. But...... ????? I can remember a song from latest movie, BluffMaster : "Na biwi, na Bachcha, na baap bada, na bhaiyya, the whole thing is that ke bhaiyya, SABASE BADA RUPAIYA".

If such scenario persists, all talent will march towards software industry, bcoz of parents force, $$$$ attraction, desire for prestigious look, aiming for good life partner, flying abroad, and wht not ? and.................................. ???????