Search results 63

Sorted from new to old.

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

ArrSort_4Arr

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

2023Apr14

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

ANStrSort2

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

2020Sep24

Online JSON Formatter

Online JSON Formatter, helpful when you suck at json, found it during my search ...

2020Aug26

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

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

1 2 3 4