Search results 60

Sorted from new to old.

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

ASPZip

Zipping in ASP Classic, would love to test on my next project.

2025Jun6

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

2024Feb27

Mini Ajax-php upload form

Simple elegant form to upload files with php/ajax. From

2024Feb15

SQL Cross Apply String_Split with XML Path

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

2024Jan20

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

1 2 3 4