Tuesday, October 6, 2020
Sort JSON Array with Value
›
Example:Sort JSON Array mydata = [{ "id": 1, "first_name": "Jean", "last_name": "Esome&...
Thursday, September 10, 2020
Selecting distinct values from a JSON
›
eData is the JSON array var items = eData.map((d)=> {return d.year}) var uniq = items.filter(GetUnique) function GetUnique ( value , ...
Thursday, August 6, 2020
Replacing SharePoint Designer with VS Code
›
“Replacing SharePoint Designer with VS Code” - install VS Code - Add extension SPGO to your VS Code - Execute following 2 thing ------ Conne...
Wednesday, August 5, 2020
Unable to open SharePoint Designer Site
›
Unable to open SharePoint Designer Site Remove all the content from following folders to avoid issue %APPDATA%\Roaming\Microsoft\Web Server ...
Monday, July 27, 2020
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 = App...
Excel To PDF with VBA
›
Sub ConvertExcelToPDF() 'Export Single Sheets ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="TrainingDeo", ...
Friday, July 24, 2020
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 wher...
‹
›
Home
View web version