Search results 567

Sorted from new to old.

LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

2019Jun28

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

IsThere_Remote

Checks if a file can be reached online or no Same as

2019Jun7

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

2019Jun2

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31

fnGenerateRandomString

SQL function to generate random string I thought it would be easier to find ...

2019May5

eMailMe (CDO)

Single asp file (having function) to send an email It is used here to send an ...

2019May3

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

1 2 ...20 ...35 36