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
Post a Comment

MS Excel currency converter - Number to words Latest version

-
MS Excel currency converter 3.0 has been updated with bug fixes.

This is the new version of my amazing currency converter VBA utility for MS Excel. The macro will convert the currency number which is in number to text. For example, Rs. 14,250 is a common standard to represent the money of Indian Rupees Fourteen Thousand, Two Hundred and Fifty. This VBA code takes the input as 14250 and prints as 'Fourteen Thousand, Two Hundred and Fifty'.

It can be used in writing cheques, generating financial reports, MIS reports, and other accounting purposes. If you are familiar with accounting software such as Tally, you will know that the current number is converted into text. But this feature is not available in MS Excel.

The earlier version had few bugs which were reported by the users. I have fixed them in this version. 

Below is the list of bugs fixed

1. For 1000 and 100000 it was resulting in a null string. Now it has been fixed.

You can download the VBA module here. After downloading go to your Excel VBA editor. Then, go to Insert Menu, Insert Module. Paste the VBA code just downloaded. Go back to your excel spreadsheet by pressing ALT+F11. Start using the new function.

Download

Download here the Complete Excel.

Download
Please let me know if you have any specific questions to currency converter or any generic VBA code questions. If you are looking for any new features in MS Excel or MS Word, I will try to implement them in using the VBA code.  

Comments

  1. UnknownMay 20, 2014 at 9:05 PM

    I have installed this module ... In my case for when i enter "2000" it shows as "twenty two thousand"
    Thanks for your help

    ReplyDelete
    Replies
    1. Krishna SNovember 15, 2014 at 12:25 PM

      I could not reproduce this error. Please re do the steps again.
      I have release a latest version 4.0 with some bug fixes. Take look at it once

      http://krishnasr.blogspot.in/2014/11/latest-version-of-latest-version-4.html

      Delete
  2. ArtiOctober 30, 2014 at 5:18 PM

    Krishna,your code gives errors for numbers greater >2000 & nos in lacs. Just as Murthy mentioned the code shows "twenty two thousand" for 2000 & "twenty two lacs" for 2,00,000.
    Please help to debug this error.

    ReplyDelete
    Replies
    1. Krishna SNovember 15, 2014 at 12:27 PM

      Hello Arti,

      Thanks for notifying me the issue with 2,00,000. I Have fixed it in the latest version

      http://krishnasr.blogspot.in/2014/11/latest-version-of-latest-version-4.html

      Your feedback will encourage me

      Delete
  3. AnonymousApril 26, 2015 at 2:02 PM

    Word Rupees should be before not after.
    For Ex. Rupees One Lac Fifteen Thousand Two Hundreds Fourty Five & Twenty Five Paisa.

    ReplyDelete
  4. AnonymousJune 11, 2016 at 12:36 PM

    How to use the function in excel file

    ReplyDelete
  5. UnknownSeptember 9, 2016 at 4:29 PM

    Thank you for your great post. It's really very informative and really helpful. Please Keep posting. Thanks again.
    23Traders Tutorial

    ReplyDelete
  6. juanjuergensMay 22, 2017 at 9:01 PM

    Someone Sometimes with visits your blog regularly and recommended it in my experience to read as well. The way of writing is excellent and also the content is top-notch. Thanks for that insight you provide the readers!
    excel vba courses london

    ReplyDelete
  7. UnknownAugust 12, 2017 at 12:07 PM

    where i find this Add In to convert the currency?

    ReplyDelete
  8. UnknownDecember 8, 2017 at 4:48 PM

    Thanks for this post, I really appriciate. I have read posts, all are in working condition. and I really like your writing style. Keep it up like.
    Buy Car Battery Online

    ReplyDelete
  9. Aalisha SharmaDecember 13, 2017 at 10:36 PM

    Like your work..very nice keep doing good work.

    Compress JPG online
    Compress PNG Online
    Online JPEG Compressor Tool
    convert png to jpg without losing quality
    Online Image Optimizer
    JPG Size Reducer
    Photo Compressor

    ReplyDelete
  10. Jayden RichFebruary 6, 2018 at 11:15 AM

    I enjoyed this and I will be back for more. Foreign Currency Exchange

    ReplyDelete
  11. Inesta HenryAugust 28, 2018 at 6:41 PM

    Calculate the live currency and foreign exchange rates with free currency converter. You can convert currencies instantly. I recmonded you Currency calculator app through this you get more results about Money converter .

    ReplyDelete
  12. Anna SchaferSeptember 2, 2019 at 5:45 PM

    I read that Post and got it fine and informative. Please share more like that... convert money

    ReplyDelete
  13. gossipJune 25, 2022 at 5:53 PM

    This is such a great resource that you are providing and you give it away for free. Gossip

    ReplyDelete

Post a Comment

Popular posts from this blog

Connecting Bluetooth headset with laptop - Bluetooth A2DP

-
A normal phone Bluetooth headset can be easily connected to a laptop and it can be used as earphones or headphones while using skype, gtalk, WhatsApp, or any other voice chat services or of course to listen to your favorite music. All you need to do is a Bluetooth device and the Bluetooth driver with the A2DP(Advanced Audio Distribution Profile) profile. Here is the detailed procedure the setup Bluetooth device with your laptop. Download the A2DP Bluetooth driver from the link provided below. Extract the zip file 'Bluetooth A2DP Driver For Windows.zip'. Go inside the folder 'Bluetooth A2DP Driver For Windows', double-click on the installer file 'anyone-Bluetooth-usb2x0-WindowsXP-v2-1-0-4.exe'. Follow the onscreen instruction to complete the installation.  Once the A2DP driver is installed successfully, Switch on the Bluetooth in the Laptop and Headset. Look for the Bluetooth device the list of available Bluetooth devices. If it is not visible yet, select Add
Read more

Convert currency to word in excel

-
There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ###,###,### (comma at every third number)format.  This is not suitable for India numbering system, because we follow ##,##,###(....22,22,222) format. So I have create a excel function to over come this. You can use this function to to convert number up to 10,00,00,000(ten crores). How to do it Open Excel Press Alt + F11 From Menu Bar  Insert Module Copy paste the This Module there. Exit from VBA window by pressing Alt + F11 again In excel sheet, Insert Function, Under user defined find   ConvertCurrencyToEnglish  select it and provide the number as a parameter thats all you are done ---------------------------------------------------------------------- Code (alternatively you can download the module from here ) ---------------------------------------------------------------------- ' ****  Author                 : Kr
Read more

[SOLVED] MacBook Pro keyboard backlight not working? Check this post

-
Image
Keyboard backlight not working on your MacBook Pro? And your Mac has a touch bar?  Continue reading... MacBook Pro 2020 which comes with a touch bar has moved its Keyboard backlight controls to the touch bar. You will not see any control on the screen under the Keyboard settings. But the setting in the touch bar is also not easy to see and it bit tricky. You most probably, think that there is some issue with Keyboard. Even the support people suggest resetting some of the settings. That is what happened with my case. Luckily I found a way to change the settings.  By default, the Keyboard backlight settings are not visible on the touch bar. You have to expand the tra-like stuff on the touch bar and then you will find icons, which look similar to screen brightness control icons.  On the right side of your touch bar, you will these 4 controls 1. Screen Brightness control  2. Volume control  3. Mute control  4. Siri button.  Left these controls there is an arrow button which looks like '
Read more