Create QR-Code with VBA

Function to add QR-Code as image in your file.

Function Insert_QR(codetext As String)
	Dim URL As String, MyCell As Range

	Set MyCell = Application.Caller
	URL = "https://chart.googleapis.com/chart?chs=125x125&cht=qr&chl=" & codetext
	On Error Resume Next
	  ActiveSheet.Pictures("My_QR_" & MyCell.Address(False, False)).Delete 'delete if there is prevoius one
	On Error GoTo 0
	ActiveSheet.Pictures.Insert(URL).Select
	With Selection.ShapeRange(1)
	 .PictureFormat.CropLeft = 10
	 .PictureFormat.CropRight = 10
	 .PictureFormat.CropTop = 10
	 .PictureFormat.CropBottom = 10
	 .Name = "My_QR_" & MyCell.Address(False, False)
	 .Left = MyCell.Left + 25
	 .Top = MyCell.Top + 5
	End With
	Insert_QR = "" ' or some text to be displayed behind code
End Function

Excel To PDF with VBA

 

Sub ConvertExcelToPDF()

'Export Single Sheets

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="TrainingDeo",      OpenAfterPublish:=True

'Export Multiple Sheets

Sheets(Array("RemovingDuplicates", "HideUnhide", "ExportToPDF")).Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="TrainingDemo2", OpenAfterPublish:=True

Sheets("ExportToPDF").Select

Range("A1").Select

End Sub

Reference Code at YouTube

SQL Query to find all tables in a Database containing specified column name

Following query will help to find field name available in any of the table in a database.

SELECT * from INFORMATION_SCHEMA.COLUMNS 
where COLUMN_NAME like '%ColumnName%' 
order by TABLE_NAME



SQL Server:

SELECT Table_Name, Column_Name 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'YOUR_DATABASE'
AND COLUMN_NAME LIKE '%YOUR_COLUMN%'


Oracle:

SELECT owner, table_name, column_name 
FROM all_tab_columns 
WHERE column_name LIKE '%YOUR_COLUMN_NAME%'

AND OWNER IN ('YOUR_SCHEMA_NAME');

Sort JSON object Array

Sort JSON object Array

var array = [{ "No": "12", "Name": "Sameer Patel", "Training": "SharePoint" }, { "No": "2", "Name": "Syam Shah", "Training": "ASP.NET" }, { "No": "11", "Name": "Sunil Shah", "Training": "JAVA" }, { "No": "8", "Name": "Arun Nair", "Training": "Sql Server" }, { "No": "6", "Name": "Anil Patel", "Training": "C#" }]; //Sorting Function function SortBy(prop) { return function(a, b) { if (a[prop] > b[prop]) { return 1; } else if (a[prop] < b[prop]) { return -1; } return 0; } } //array.sort(SortBy("KeyName")) array.sort(SortBy("No"))

Convert Dropdown to Textbox with JQuery

Here is the simple way to convert dropdown to text.


<style> .red{background:red;} </style> <select id='ddl'> <option value='1'>Item1</option> <option value='2'>Item2</option> <option value='3'>Item3</option> <option value='4'>Other</option> </select> <select id='ddl2'> <option value='1'>Item1</option> <option value='2'>Item2</option> <option value='3'>Item3</option> <option value='4'>Item4</option> </select> <script> //runtime on selection of option = 4 $('#ddl').live('change', function () { if ((this.value) == 4) { $(this).replaceWith($('<input/>',{'type':'text','value':'Other'})); } }); $("#ddl2").replaceWith($('<input/>',{'type':'text','value':'Other','readonly':'readonly','class':'red'})); </script>

Extract only text content from HTML in Javascript

1. Create a temporary DOM element and retrieve the text

/* Returns the text from a HTML string */ function GetPlanText_FromHtml(html){ // Create a new div element var tmp = document.createElement("div"); // Set the HTML content with the providen tmp.innerHTML = html; // Retrieve the text property of the element (cross-browser support) return tmp.textContent || tmp.innerText || ""; } var myHTML_String= "<div> <h1> Hello World</h1> <p> This is Extracted string from HTML</p> </div> "; //Hello World //This is Extracted string from HTML console.log(GetPlanText_FromHtml(myHTML_String));

2. using jQuery

var myHTML_String= "<div> <h1> Hello World</h1> <p> This is Extracted string from HTML</p> </div> "; var HTML2Text= $("<div> ").html(myHTML_String).text();

JQuery to create Download Link

Simple way to download file without navigating.

function downloadFile(filePath){ var link=document.createElement('a'); link.href = filePath; link.download = filePath.substr(filePath.lastIndexOf('/') + 1); link.click(); } downloadFile('filepath/myfile.xlsx');