Search results 40

Sorted from new to old.

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

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

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

PCase

Converts a string into proper case PCase or ProperCase since Classic ASP does ...

2018Sep7

Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19

1 2 3