Search results 61

Sorted from new to old.

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

ReadHTMLTag

Reads string between open and close HTML tag (between < ... > and < / ... >), ...

2020Aug15

Sorting Strings

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

2020Jul22

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Capitalize in JS

Convert text to all capital letters

2020Feb16

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

Barcode Generator

Pure ASP Classic barcode generator This is one of my past findings, I will be ...

2020Feb1

1 2 3 4