Search results 580

Sorted from new to old.

Times_inHours

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

2023Jul20

Refresh Table from View

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

2023Jul19

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

2023May25

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

Range22DimArray

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

2023May11

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

ANmaDate

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

2023Apr27

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

DB Functions (By AI)

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

2023Apr23

WordPress - Excel functions (AI)

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

2023Apr22

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

ArrSort_4Arr

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

2023Apr14

1 2 ...11 ...36 37