This area of the site is dedicated to code snippets for quick and easy reference
I recently needed to see what zip codes in Michigan were missing from a table of zip codes that I have in a database. First I had to get an official list of zip codes for Michigan then came up with this script to figure out which of the official codes were not in the…
I found and modified code to create an Ektron Library File Upload function. This function allows some customization: Defined Folder ID In this code I manually set the folder ID but effectively you could have a drop down list of folders to select the folder (see DMS Widget) Content Title This is used in the…
Following my code on Ektron – DMS Content List I created this Ektron Widget
I found this code on the Ektron Developer Center (see link below) that pertained mainly to menus but assisted me in getting a folder drill-down so I could add it into my DMS content widget. Similar to the DMS content widget make sure you setup the proper permissions to the page that lists these as…
See JSFiddle: JSFiddle Resource: CSS-Tricks.com
In a recent effort to clean up duplicates in my contacts I came across a script to assist me. In my situation I have some contacts that have had the company name inserted as the first/last name. In my case almost all of the records could be modified to null the first and last name…
AutoFit() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+d to select all columns and rows and then set a temporary width and height to then autofit based on all the content in the worksheet. Windows macOS AutoFitHeight() is designed to run in your Personal.xlsb with a keyboard function of Ctrl+e…
Credit: fatcat1111 @ stackoverflow.com
Sometimes we need to compare lists in Excel, this function will assist in getting a clean comparison. NOTE: It is best when comparing that all columns are same format (ie. Text, Number, etc.) OR Going one step further, if you find a match and need a value from the other worksheet you can do this.In…