Search results 21

Sorted from new to old.
Card image
Formulas_FromFile_ToRow

Imports formulas from file into list of cells defined in file itself into ...

Card image
ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Card image
DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

Card image
FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

Card image
ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

Card image
CountNumbers_inString

Returns how many numbers found inside a text

Card image
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Card image
MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

Card image
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

Card image
Zoomed iframe

Show iframe zoomed or in scale Thanks to

Card image
New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

Card image
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

Card image
Input text - pre-Placeholder

Remove text when textbox is selected, then put it back if it left empty This ...

Card image
List of Databases

Script to list databases available in a server using ADODB connection From

Card image
RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

Card image
ANmaTimeline

Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...