Search results 21

Sorted from new to old.

Formulas_FromFile_ToRow

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

2025Oct11

ANStrVLookupAll

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

2025Jun14

DBTableCol_Array

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

2025May30

FilesIn_4Array

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

2025May25

ANStrSort2

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

2025May25

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

SQL Cross Apply String_Split with XML Path

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

2024Jan20

MultiRead_JSON

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

2024Jan13

FilesIn_Array and FoldersIn_Array

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

2023Aug15

Zoomed iframe

Show iframe zoomed or in scale Thanks to

2023Aug4

New VBS file

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

2022May3

Excel crashes when File > Print

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

2021Mar6

Input text - pre-Placeholder

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

2020Oct10

List of Databases

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

2019Oct6

RunRemote

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

2019Jan9

ANmaTimeline

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

2018Aug26

1 2