Search results 24

Sorted from new to old.

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

2024Feb28

VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

2024Feb25

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

Fix Excel Issue

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

2023Aug1

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

ReadLastChars

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

2023Apr20

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

ANmAdvancedFilter

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

2022Sep15

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

1 2