Nishant Verma

Notice the spelling of Google. It’s the Google’s 11th birthday !!! At first I thought, it’s typo; but then pointing the mouse shows 11th Birthday. :) Nice…

Recently I read some article in Martin Flower’s blog where he is pointing to “Excel” as the most popular programming language. Indeed it is ! I very much agree with that. It’s just a powerful tool which allows one a freedom of implementation in VBScript. I am just sharing my experience with Excel where I had to make some cells mandatory as a part of filling a form. Hope you will be benefited. Option Explicit Dim Mandatory As Range Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Cells.Count > 1 Then Exit Sub Select Case Target.Address Case "$A$5", "$A$10", "$A$15", "$A$20", "$A$25", "$A$30" Set Mandatory = Target Case Else If Not Mandatory Is Nothing Then If Mandatory = "" Then Mandatory.Select MsgBox "You cannot leave this cell blank" End If End If End Select End Sub The above macro will make the cells...

Below is a piece of code which can be used to read excel sheet and the values in the row or column. Option Explicit Dim myExcel,strExcelPath,objSheet Dim intRow,strRow2Col1,strRow2Col2 Set myExcel = CreateObject(" Excel.Application ") strExcelPath = "C:\Book2.xls" myExcel.WorkBooks.Open strExcelPath Set objSheet = myExcel.ActiveWorkbook.Worksheets(1) 'Assuming that the first row will contain the name of the column intRow = 2 Do While objSheet.Cells(intRow, 1).Value <> ""     strRow2Col1 = objSheet.Cells(intRow, 1).Value     strRow2Col2 = objSheet.Cells(intRow, 2).Value 'Increment the control to the next row     intRow = intRow + 1 Loop myExcel.ActiveWorkbook.Close myExcel.Application.Quit

View Full Album

In the present era we have a deep presence of mobile & internet in our life. People are driven by socio-emotional need to get connected with their friends, families, information and entertainment. As per the latest research, people are using their mobile to access internet as much as they use traditional web. Apart from all this, we would have hardly noticed but mobile phones are intensely personal devices which we carry with us almost everywhere. As a result, it is hard-to-resist medium for advertisers and proves to be the most intrusive form of marketing. Mobile Services typically involve two big players: Carrier & End User. Carriers generally weigh different strategies to approach the market and look for different user segments. But we are witnessing the third player coming into picture: Advertiser. If we try understanding the entire situation, it is carrier which is interfacing both user & advertiser and they have to do the balancing act between the two. The big...

Scheduling Google Search and getting the results on your Mobile. I was reading an article on Tech Crunch about Google and I got an idea. If it is Google it has to be Search. If I see the web site I see it perfect. There is nothing a person would want ; a simple User Interface with text box and button. But what if I don’t have access to internet tomorrow just in case if I am traveling or not at my laptop or not having access to internet in but I know that I will need it to search something. For example when I am in Mysore Road (Let's say Wonder La) and I might be looking for some information on the good restaurants around. And I saw myself imagining the Google page with a “Schedule” button which allows me scheduling the search in future (may be 2-3 days in future) and not only this but also delivering the top 10 or 15 search result onto my cell phone. This sounds cool I suppose. Now this feature will really be good and handy but I also think how many users will be like me needi...

Title may sound weird to many of you but I could not get any suitable title than this. This line is one among the many dialogues which Spartan king speaks in movie 300. I watch this movie on almost every weekend (I have this movie stored on my laptop HD). Well this blog is no where related to 300. This blog is about cloud computing. What is cloud computing? Why cloud computing will make it real big? What is cloud computing? Cloud refers to the internet and computing refers to IT related services. When computing services are available on cloud, same is referred as cloud computing. In IT layman’s word it is like availability of virtual servers for internet. In academics we learn about many concepts like Grid computing, Cluster computing etc… but let’s not confuse those concepts with cloud computing. Cloud computing is not at all grid computing or cluster computing. Why cloud computing will make it real big? Let’s discuss few reasons why cloud computing will make it real big. 1. Cu...