Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Saves txt file as word doc with password. Passing txtfile having full path and ...
Jan4
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Register an extension in Windows registry for extension with an application. ...
Nov25
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...
2022Jul3
Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...
2022May4
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
Exports range to an image, something we wanted to be able to do for a while now. ...
2022Feb16
Creates HTML file using template found in a column. Have lines of HTML in a ...
2022Feb5
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Matching any part of a string in another , then returns 0 if not match, Or ...
2018Jun26
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
2018Jun14
Returns list of files found in a folder, list separated with custom separator
2018Apr23
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
2018Apr14
Checks if an item was found in list of items and return 1 if yes, 0 if not ...
Dec19
Returns list of files found in a folder, list separated with custom separator ...
2018May22
Creates list of unique items found in a column, returns string with items ...
2020May6
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Adjust iframe height to its content after loading page Needed this trick in ...
2023Apr29
Opens an image using Irfanview (i_view32.exe attached which also inscludes a ...
2019Jul8
2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...
2018Jun24