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
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
Adds an amount (or subtract) from a range of cells in one click
Similar to
2023Feb18
Removes last row in a table starting certain cell. Creating and using this ...
2022Aug16
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
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
Get the ID of the last inserted record in a table. There are other methods, ...
2019Jul18
Finds last occurrence of a match in a column Finds the row of last time an ...
2019Jun12
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...
2018Jul17
Asks user to browse to a file and return full path and file name if they do, ...
2018Jul17
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Adds an amount (or subtract) from a range of cells in one click
Similar to
2023Feb18
Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
Ranks a number among set of numbers. This is part of huge tool, we needed to ...
2021Sep23
Unmerges all merged cells and duplicate cell contents into them. In another ...
2019Apr16
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 ...
Apr30
Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...
2021Feb24
Responsive Tags Input With Autocomplete Examples using Bootstrap 4 Originally ...
2020Oct9
Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...
2020Feb19