Search results 27

Sorted from new to old.

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

ANmaRename2Files

Quick batch file to rename two files. One of my big sources of images for my ...

2025Mar16

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

2023Aug14

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

IfFoundInList

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

2023Jul24

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

Windows 10 video files and OneDrive

Fixing generating videos thumbnail in Windows 10 Download app from

2020Oct31

Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

2020Oct11

Numeric Input Spinner

A nice Bootstrap 4 numeric spinner used on Input box Originally from

2020Sep17

AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

2019May20

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

1 2