Search results 66

Sorted from new to old.

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

ANmaHTMLContent

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

2023Jul1

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

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

ForegroundColor

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

2023May5

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

1 2 3 4 5