Skip to content

Instantly share code, notes, and snippets.

View shabbirbhimani's full-sized avatar
💭
:)

Shabbir Bhimani shabbirbhimani

💭
:)
View GitHub Profile
Option Explicit
'Main Function www.ExcelDataPro.com
Function SpellNumberEDP(ByVal MyNumber, Optional MyCurrency As String = "")
Dim Dollars, cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
Option Explicit
'Main Function www.ExcelDataPro.com
Function SpellNumberEDP2(ByVal MyNumber, Optional MyCurrency As String = "")
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count, x
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Lacs "
Place(4) = " Crores "
Place(5) = " Hundred Crores "
Option Explicit
'Main Function www.ExcelDataPro.com
Function SpellNumberEDP(ByVal MyNumber, Optional MyCurrency As String = "")
Dim Dollars, cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
Option Explicit
'Main Function www.ExcelDataPro.com
Function SpellNumber1(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "
Option Explicit
'Main Function www.ExcelDataPro.com
Function SpellNumberEDP2(ByVal MyNumber, Optional MyCurrency As String = "")
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count, x
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Lacs "
Place(4) = " Crores "
Place(5) = " Hundred Crores "
@shabbirbhimani
shabbirbhimani / .htaccess
Created June 3, 2020 12:05
Redirect old domain to a new domain .htaccess
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{HTTP_HOST} ^old-domain\.com$ [OR]
RewriteCond %{HTTP_HOST} ^www\.old-domain\.com$
RewriteRule (.*)$ https://www.new-domain.com/$1 [R=301,L]
</IfModule>
@shabbirbhimani
shabbirbhimani / .htaccess
Created June 3, 2020 11:53
htaccess redirect .php to .html
# Part of SEO Interview Questions - https://imtips.co/seo-interview-questions.html
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME}\.php -f
RewriteRule ^(.*).php?(.*)$ $1.html?$2 [R,L]
</IfModule>
@shabbirbhimani
shabbirbhimani / functions.php
Created December 18, 2019 08:04
Add GTM Code to WordPress Blog
<?php
//* Copy the above PHP opening tag if and only if your functions.php has a closing PHP tag
function add_gtm_head() { ?>
<!-- Paste Your GTM Header Code Here -->
<?php } add_action('wp_head','add_gtm_head',10);
@shabbirbhimani
shabbirbhimani / functions.php
Created December 15, 2019 10:31
Add Google Analytics to WordPress Blog
<?php
//* Copy the above PHP opening tag if and only if your functions.php has a closing PHP tag
function add_google_analytics() { ?>
<!-- Paste Your Google Analytics Code Here -->
<?php } add_action('wp_head','add_google_analytics',10);
<?php
/*
* Source code by WES of Stackoverflow
* https://stackoverflow.com/questions/3657023/how-to-detect-shot-angle-of-photo-and-auto-rotate-for-website-display-like-desk/18919355#18919355
*/
function correctImageOrientation($filename)
{