Search results 21

Sorted from new to old.

Notes bad for speed

Excel macros performance Adding Notes to cells does affect speed in running ...

Sat 2PM

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

ANmaHTMLContent

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

2023Jul1

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

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

Sorting Strings

This is not a function as much as a note. I needed to force a line to show at ...

2020Jul22

Functions.dll

Old DLL housing list of functions to be used and called by any application, ...

2020Jul18

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

1 2