Search results 141

Sorted from new to old.
Card image
WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Card image
Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

Card image
Luhn

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

Card image
Times_inHours

Calculate the total number of hours between two times and return in format ...

Card image
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Card image
DB connection driver

What is the Driver part in ConnectionString

Card image
ForegroundColor

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

Card image
DB Functions (By AI)

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

Card image
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

Card image
ArrSort_4Arr

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

Card image
Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

Card image
OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

Card image
ANmaVLookup

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

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...