Search results 640

Sorted from new to old.

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

2019Mar30

ANma_HTML2DB + ANma_DB2HTML + ...

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7

FilesCount_Swift

Count how many files in a folder, with no loop, faster if you just need all ...

2019Feb2

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

RoundMinutes

Rounds time into nearest quarter up or down, half up or down based on argument ...

2019Jan9

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Dynamic ASP include

ASP function replaces the standard "include" statement, allowing a TRUE working ...

2019Jan6

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

FormatMyDate

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

2019Jan4

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

1 2 ...25 ...39 40