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...
Thursday, July 16, 2020
Sort JSON object Array
›
Sort JSON object Array var array = [{ "No": "12", "Name": "Sameer Patel", ...
‹
›
Home
View web version