Random codes

Random 24 Codes by our developers.

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

2020Jul22

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

VHD files 950MB + 1.8GB + 3GB

VHD files, 950MB, 1.8GB and 3GB, helpful when you want to quickly save files ...

2018Nov8

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Auth_User

Find the user name (and domain) for logged in user for in an internal intranet ...

2020Feb23

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Steps Recorder Win10 app

Win10 application already found in Windows. to generate list of steps with ...

2024Feb16

WindowsProgress Preloader

Windows progress preloader in JS From

2019May5

Win98 css theme

Win98 CSS in html Similar to Win95 CSS

2023May29

List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

Bootstrap Editable Table

Editable table with Bootstrap 4, with multiple controls, having: Checkbox for ...

2020Oct6

Steps Circular Progress

Circular progress steps template, using Bootstrap and fontawesome

2019Sep26

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

2024Mar4

Copy File

Copys a file from one location to another using WSH

2018Apr23

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7