Showing posts from 2016

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

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          

How to merge 2 or more MS word documents

How to merge 2 or more MS word documents. You can do this by manually copying the first file and pasting on to the second file. But if you have too many files to merge and if you have to do it repeatedly, it's better to have automated setup. Below macro will help you to merge 2 documents. You can edit the VBA code and add more files if you want. After merging, it will save as a new document. By default, it will save the new merged file under My Documents. If you want the new files to be saved under a specific location, you can mention that the file name section Sub Merge_2_files() ' Merge 2 files and save as a new document NewFileName = "NewFile_" & Minute(Now) & "_" & Second(Now) & ".docx"     Selection.EndKey Unit:=wdStory     Selection.TypeParagraph     Selection.InsertFile FileName:="C:\Users\inksanjeev\Desktop\A folder\Specifications.docx", Range:="", _         ConfirmConversions:=False

How to get Unlimited Jio preview offer with Redmi Note 3

If you follow these steps carefully you will get the unlimited offer with Jio on your Redmi note 3. Get the old apk of MyJio app from below link Install MyJio and then all 11 applications from the app store do not open any application Turn off your data/wifi Open the MyJio app, then click on MyJio again. You will see 3 options Get Jio SIM, Sign In and Sign Up. Select Sign in Enter your Jio ID and Password. You can generate your Jio ID by linking your Jio number with email ID on Do not click on Sign In. Just enter the ID and Password. Turn on the data/wifi Click on Sign In. You have to try a couple of times to get to the next screen where it will ask you to submit.  Once you get the submit button click that and that's all. Your unlimited offer is credited. Enjoy unlimited Digital life for 3 months. Please your story on the comments below.

How to get Jio Unlimited Preview offer with Samsung Galaxy mobiles

Last week, Reliance had extended its Jio preview offer for Samsung galaxy users. A lot of people are itching to get one with a preview offer. This offer gives you unlimited 4g data, unlimited voice, and unlimited SMS for 90 days. I am one of the lucky guys to get a new Jio SIM with my Samsung Galaxy A5 2016. I got it on Saturday evening at 7 O’clock and the guy at Reliance digital said it will be activated by Monday afternoon. But I got it activated on Sunday, 2 O’ clock itself. That was very quick. How to get the preview offer with Samsung galaxy mobiles First, you need to install the Jio app called MyJio. As soon as you open the app, on the very first screen, you will see Get Jio Preview Offer on top of the screen. Click this and proceed with the other steps. In the first screen after clicking Get Jio Preview Offer, you will see the details for the offer and terms and conditions. Click "Agree and get Jio Offer". Next, you will have to check the eligibility.

How to create MS Word document automatically by inserting text file content to the word document

There are many situations you may want to automate the MS Word document creation. In my previous posts, I have explained how to automate document generation using VBA. It was to create a new document. Every time you run the VBA code, it will create a new MS Word file. How to create a template in MS Word Now, I will explain how to insert a text file into the document as is at a specified location into an existing document. This is very useful if you are modifying an existing document. The main feature of this VBA is, it can insert new content at a specific location. That means you can insert new content into any part of the existing document, not just append the new content at the end of the file. The first step is to create a bookmark in the word document where the text file content will be pasted. Then, open the text file using VBA code and paste the content at the bookmark. Save the file with a different name. Before saving optionally you can remove the bookmark. Below video sh

How to make a copy of current document MS Word automation with dynamic fields

How to make a copy of the current document using VBA in MS Word It makes use of the dynamic fields to create a new document with different values. The MS word document can be used as a template file. Using this template you can create a new document without much effort. Click on the button and fill the necessary information. And the document will be created at the specified location. Edit the macro and modify the hardcoded values as per your needs. Change the location of the target file. The new file will be created and stored at this location  This video explains the detailed steps to create and use this template. Part 1:  how to use dynamic fields in ms word you can download the ms word file here