Code related to Excel Macros: In this article I am trying to explore some important code related to VB macros which can help you to write robust VB macro based excel project. For all code I am using the “Test.xls” excel file which have two work sheets: 1. Inventory 2. Payroll Add the following reference to project: 1. Microsoft Excel 12.0 Object Library 2. MicrosoftOffice 12.0 Object Library 3. Microsoft Forms 2.0 Object Library 4. Microsoft Scripting Runtime i. If you want to find total numbers of used rows and columns in the work sheet Payroll: Dim wsheet_Payroll As Excel.Worksheet Dim USEDROW_Payroll As Long Dim USEDCOL_Payroll As Long ‘Create connection to Payroll worksheet Set wsheet_Payroll = Worksheets("Payroll") ‘Activate the Payroll shett wsheet_Payroll.Activate ‘Find total number of Used Row in the Payroll sheet USEDROW_Payroll = wsheet_Payroll.UsedRange.Ro...

Send Mail using System.Web.Mail object in C#(C-Sharp): I n Visual Studio 2005 microsoft provided the new mail component called System.Web.Mail for sending email. In this article I am defining you that how can you send the mail in HTML format with attachment. Add the reference to System.Web.Mail. In this article I am using the function sendMail for sending email with attachment. The definition of function is sendMail(string strFrom, string MailID, string strLogFile). In this strFrom variable contains the email address of person who are sending the mail, MailID contains the email addresses of person to whom mail would be send and strLogFile contain the physical path of log file, which send as a attachment. The body part of the function is: public void sendMail(string strFrom, string MailID, string strLogFile ) { string strMessage; string ToMail_ID; string strYourEmail = strFrom; // from mail id System.Web.Mail.MailMessage sMail = new MailMessage(); ToMail_ID = M...

Add/Update/Delete operations on the Sharepoint List Item using C#(C-Sharp): The list present in the SharePoint serves as a table which we used in the relational database. Its means in SharePoint we used list for storing user data instead of table used in RDB. These lists contain data which are required by the user for doing some computational operation or for other functionality. Here I am taking the scenario of the User List for storing user details. This list contain the details of user i.e. first name , last name and email id. With the help of this list I will explain you, how you can add/update/delete items in the list with the help of C#(C-Sharp). First add the reference to Microsoft.SharePoint. After that create the object of SPSite: SPSite oSiteCollection = new SPSite( ); siteName should be the url of your sharepoint site. Now create the object of SPWeb with the help of SPSite object: SPWeb oWebsiteRoot = oSiteCollection.OpenWeb(); oWebsiteRoot.AllowUnsafeUpdate...

I think, you can't control what people say or think about you. You can't control the decisions prospective clients make. You can't control the economy, the stock market or the weather. In this unstable environment, there is one thing over which you have absolute control: your integrity. One thing which is true for all that no body can stole your destiny. If somebody tries to steal it from you but then you can save it with your integrity. You can’t exhibit your integrity; it drives from the mathematical term: integer. An integer is a whole number. It is not divided. If a person has integrity, he/she is the leader. Their lifestyle doesn’t change with the time because their morals, ethics and treatment towards other person remains same all the time. Integrity is the pillar of leadership. Integrity determines the way we work within the Group. There is no alternate of personal integrity. At a time when an employee faces a difficult situation he/she should think on these...