Search results 211

Sorted from new to old.

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

ANmaBatchCreate + ANmaBatchRun

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

2022Aug25

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

ArrSort_3Arr

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

2022Jul24

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

DBTables

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

2022Apr28

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

1 2 ...7 ...13 14