Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
Register an extension in Windows registry for extension with an application. ...
Nov25
Reads last some characters of a file, needs to see contents of large files that ...
2023Apr20
Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...
2023Mar14
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
2022Aug18
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
Creates a folder for a user, usually after sign up or login for first time
2018Jul9
A directory Viewer with the option of downloading the file and reading text ...
2018Apr23
Returns date in human format. Which is as follows... Just day name (and time) ...
2023Apr27
Counts the number of business days Add or subtract a number of business days ...
Oct11
Number of Business days between two dates. Note that it doesn't take Christmas, ...
Oct25
Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...
Aug8
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
I hate it when Windows forcing us to have additional items in "This PC" So, I ...
Feb5
Calculates Unix date/time number of a given date/time. Needed it to pass ...
2023Jan6
Free from apress website
https://www.apress.com
More books
2021Mar2
Ready to use exe application that helps you switching the desktop in Windows 10 ...
2020Mar6