tanzilhuda

VBA Code:
Instruction: 
Step-1: alt+F11
Step-2: Insert>Module
Step-3: Input/Write the Code
Step-4: Click Run Sub/UserForm (F5)
-----------------------------------
1. Rename Sheet basis of row or column name

Sub RenameSheet()

tanzilhuda

1. Age Calculator: =DATEDIF(M2,TODAY(),"Y") & " Years, " & DATEDIF(M2,TODAY(),"YM") & " Months, " & DATEDIF(M2,TODAY(),"MD") & " Days"
=DATEDIF(M2,N2,"YM") & " Months, " & DATEDIF(M2,N2,"MD") & " Days"
Only Month
=DATEDIF(A2,B2,"M")  [1st is small, 2nd is large Date]
Only Year
=DATEDIF(A2,B2,"Y")  [1st is small, 2nd is large Date]
			
2. Count:
	a. Counting Specific name:  =COUNTIF(F2:F10, "MISSED")

tanzilhuda

Sub RenameSheet()

Dim rs As Worksheet

For Each rs In Sheets
rs.Name = rs.Range("B2")
Next rs

End Sub

tanzilhuda

Sub bleh()
    Dim xWs As Worksheet
    Set xWs = ActiveSheet
    ThisWorkbook.Worksheets.Select
    Rows("10:20").Select
    Selection.Delete
    xWs.Select
End Sub

tanzilhuda

==========================
--------Ascending---------
==========================
Sub SortSheets1()
    Dim I As Integer
    Dim J As Integer

    For I = 1 To Sheets.Count - 1
        For J = I + 1 To Sheets.Count
            If UCase(Sheets(I).Name) > UCase(Sheets(J).Name) Then

tanzilhuda

Sub GetSheets()
'Update ExcelJunction.com
Path = ""
Filename = Dir(Path & "*.xls")
Do While Filename <> ""
Workbooks.Open Filename:=Path & Filename, ReadOnly:=True
For Each Sheet In ActiveWorkbook.Sheets
Sheet.Copy After:=ThisWorkbook.Sheets(1)
Next Sheet
Workbooks(Filename).Close

tanzilhuda

use Illuminate\Support\Facades\Schema;


public function boot()
{
    Schema::defaultStringLength(191);
}

tanzilhuda

onclick="return confirm('are you sure to delete!')"

For Bootbox js
==============
CND: 
https://cdnjs.cloudflare.com/ajax/libs/bootbox.js/4.4.0/bootbox.min.js
html: 
id="delete"
Example: 
<a id="delete" href="#"><button class="btn btn-outline-danger">Delete</button></a>

tanzilhuda

RewriteEngine On
RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /(.*)index\.php($|\ |\?)
RewriteRule ^ /%1 [R=301,L]

RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

tanzilhuda

config.php
------------

<?php
define("DB_HOST", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");
define("DB_NAME", "your_db_name");
?>