Knowledge Sharing
by Paracon Consultants
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
Function WordsToNumber(SpelledNumber As String) As Double
by Paracon Consultants
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...
by Paracon Consultants
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...
by Paracon Consultants
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...
by Paracon Consultants
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...