Search results 221

Sorted from new to old.

Times_inHours

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

2023Jul20

O365 Blocked Macros

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

2023Jul10

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

SubZero

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

2023May23

ANmaInt

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

2023May2

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

ReadBinaryChunk

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

2023Apr28

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Progress in two nested loops

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

2023Mar7

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

1 2 ...6 ...13 14