WELCOME TO KRUMHOLT.NET krumholt.net logo

4:00 PM 8/4/2016
Beautiful Bird

Listed below are links to articles and software I hope you will find useful.


This macro enabled spreadsheet lets you import your file system details directly into a spreadsheet.

You can choose by file extension, folder, or you can pull in detail about every file on a hard drive, thumb drive, or network store. It can help rename, move, copy and or delete files. Use this spreadsheet to keep track of your PDF files, add document and photo descriptions, categories, classifications etc.

You have all the power of Excel to help manage any file system. It has an interface to assist you.

You can request custom forms to further automate tasks such as simple document management.

A short demo of the file explorer spreadsheet can be observed on youtube at the following link

Request a copy of this spreadsheet by Email mailto:webmaster@krumholt.net so to insure it is authentic and has not been tampered with.

Do not accept unsolicited content from any source as genuine.

Using email will provide for additional verification and help protect you from malicious content.

If you get any of my work from any other source I recommend you contact me regarding its authenticity before you open it.

I will provide limited technical support whenever possible. mailto:webmaster@krumholt.net

Although this program allows you to access some file header data, extended parsing of the metadata is still under development. eg. photo location, camera type, etc.

This application could also be used to help catalog the contents of a storage area for forensic purposes. You may want to request a custom form dialog to fit your specific need.

Please send me your questions and or comments regarding the needs of your company or institution.
I am adding new features eg. the application can include an option to create html web pages to reference any group of files listed on your local intranet or web pages.
The idea is to use excel to manage files. If you are not familiar with excel then you will find it is a great tool for accounting.


This macro will match the values beween two sheets you identify as source and target.

The values on the target sheet in the first column 'A' are compared to values on the source worksheet in column 'A'for a matching value.

When a match between sheets for a value in column A is found, the value in column 'B' will be copied from the source and inserted into the target sheet adjacent to the matching value.

A new column will be inserted into the target sheet for the new values so no previous values would be overwritten.

The macro also creates a column in the source sheet and indicates the rows a match was found in the process.

The comparison occurs from top to bottom and ends when a blank cell is found in the target column A.

This is a 'DO IT YOURSELF' example of how to put a powerful macro to use for yourself. The source code is provided on a link below and there is a short tutorial video link.I hope you find this macro useful. It has proved to be very handy when dealing with some very large worksheets."
See the demo for this macro at
Click here for the code you can paste into your project  SOURCE CODE (TEXT FILE)

Hundred Year Date Calculator - VB Script
Hundred Year Date program dialogGregorian Date in
Hundred Year Date program dialog100 year date output.
Hundred Year Date program dialogHYD Date in
Hundred Year Date program dialogGregorian Date out

I bet you wish you had a script which could easily tell you the number of days in this century. NOoo? LOL

Well it may be something only people who use the IBM AS400 iseries computer system can appreciate, Its kinda like the startdate used in star trek but its basically a calulator for the number of days since the turn of the century.. but what the heck here is a simple script which can take a gregorian date and return the hundred year date or vice versa.

Hundred Year Date calculator- A Visual Basic Script

(If your computer hides the files extention you need to adjust the folders view settings first.)

The link below is to a plain text file. You dont even have to cut and paste. Just save it and rename it with a .VBS extension eg. HUNDREDYEARDATE.VBS or HYD.VBS

Qcall documentation
Qcall has also been created for the Android OS but is only available via email.
Quick Call - Quick Reference
Quick Call started out in the 1980's, a program running on an IBM computer and was used by a police department as a quick reference for dispatch. It was actually concieved as a solution to a serious problem as back in the day there were a lot of pay telephones and 911 hang up calls without a reference of where the emergency might exist so I created a cross-reference (phone number to location) which made it possible for a quick response. Having the cross-reference actually made it possible for the police to establish communications to anyone standing near a pay phone if the need arose. It’s a database requiring no special parameters, no special formatting. You simply enter a line of information, a thought, something you may want to look up again later. An example would be ‘PHONE NUMBER FOR DAVID 234-8233’ and later when you need to remember you just type in ‘david’ and it returns the information you entered. If you are thoughtful enough to put the data in there then you will be very happy at how well it serves to assist you recall those things you quickly forget.
Qcall dialog
The modern version of quick call has a few output options but defaults to html. You can choose notepad or a list box where items can be edited. One of the best things about Qcall is the ability to change the data source and use it to quickly parse items with matches out of computer logs or other text files.

All rights reserved by Charles Krumholt Any use requires written consent.