Knowledge Sharing

In many occasions you would want to get the sheet names of a closed workbook without opening it to make your code run faster specially if that closed workbook is of a big size. So, here we go:   'Function...

In many cases we apply multiple filters to a table, or a sheet range and we need to document what filters did we use to get the displayed values. This procedure when run on the active sheet, will create a...

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

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...

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...

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...

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...