Posts

Showing posts from December, 2016

How to create a self signed SSL certificate and how to use it with your web Server.

Image
SSL certificate is the foremost important aspect of any website. If your website is running without the SSL, the modern browsers will stop the users from entering the website. Of course, there are ways to bypass that, at your own risk. As long as your website has no commercial data exchange, sensitive user information, etc, you are still good to run a website without a proper SSL certificate. For example, a blog can run without an SSL.  Note that Google AdSense accepts websites without SSL.  But the topic of this post is about Self Signed SSL certificate. How to create one, how to use it, and where to use it.  Let us see where to use it. For any website which is used for internal purposes, it's always a good idea to use Self Signed SSL, instead of paying for a real SSL certificate. Internal I mean, within a company, team, or for personal uses, for testing purposes, etc.  Now, let us see how to create a self-signed SSL certificate.  What you need A Linux machine.  OpenSSL utility  A

MS Excel Currency converter VBA code

To convert numbers into text, there is no  builtin function in MS Excel as of now. Using the below VBA code you can overcome this issue. There are situations like writing a cheque leaf, printing a rent agreement, or writing contract documents that may require printing the transaction amount in the text. Make use of this code to convert numbers into text automatically.  Copy and paste this VBA code into your Excel VBA editor module. Or Insert an empty module and paste this code. Attribute VB_Name = "Module1" 'Attribute VB_Name = "Module2" ' ****  Author          : Krishna S ' ****  Tittle          : Converting Hindu Arabic Currency(Indian System) to Words ' ****  Copyright Owner : Krishna S ' ****  Description     : This utility converts currencies in Indian numbering system to words. ' ****  Limitations     : Converts only upto 10,00,00,000( Ten Crores) Function ConvertCurrencyToEnglish(ByVal MyNumber) Dim Temp