Knowledge Sharing

VBA Code Spelled numbers to number
VBA Code function that takes a spelled number and returns the number in digits. Example: "one thousand six hundred thirty four" will return 1634
Function WordsToNumber(SpelledNumber As String) As Double
Excel: How to Case Sensitive Vlookup formula
By default, vlookup function is non case sensitive. What if we need to do a case sensitive vlookup operation. For example, let us use the following table   As you can see, the values in column A can be repeated but with...
How to unprotect Excel sheet without password
If you prefer to watch the complete steps in a video, then visit this youtube link: https://youtu.be/eSTUQk1t1dI Below are the steps to unlock any Excel sheet if you forgot the password If your file is .xls then save it as .xlsx...
Installing Primavera on SQL Server
A step by step guide with pictures. By Default, Primavera will install Oracle database.This article shows in details how to install Primavera P6 on SQL server 2012.The same concept should apply to any other versions.    Installation is divided into...
VBA Outlook: Insert Picture Signature Without Displaying Email
Insert Picture Signature Without Email Display I have been searching the internet for a VBA code to insert my picture signature to my email and found many posts stating that to insert a picture signature you will have to display the email...