Call Us At: 701.866.2098


Run Macro in Microsoft Excel to Update Multiple Hyperlinks at Once

Suppose you have a list of data with the same hyperlinks. With VBA code, you can quickly replace the old file path or address with a new one. Here’s how to do so: 1. Press the ALT + F11 keys, to open the Microsoft Visual Basic for Applications Window. 2. Click Insert > Module, and…

Force Files to Open with Microsoft Apps When Sharing Links Using URI Schemes

URI schemes allow for office productivity applications to be invoked with various commands. Each application is given a different named scheme but all schemes follow the same rules for how the URI is formed (URI Schema). Full schema < scheme-name >:< command-name >”|”< command-argument-descriptor > “|”< command-argument > The scheme syntax includes the following: 1….

Click-to-Tweet HTML Generator

While working at Office Sign Company, in Downtown Fargo North Dakota, the Marketing Department requested various clickable links to be placed on various pages of the company site (OfficeSignCompany.com). To do this I would code up a link quick and pass it off: The above script when pasted into the HTML area of the website…

Acro-JavaScript: Flatten Form Fields

Developer Software Required: Adobe Acrobat A.K.A Adobe Acrobat Pro End User Software Required: Adobe Reader A.K.A. Adobe Acrobat Reader JavaScript can be used to lock down form fields or flatten .pdf form fields so entered data cannot be changed by a typical user. This can be extremely handy when a document is available to end…

Acro-JavaScript: Custom Submit Button

Developer Software Required: Adobe Acrobat A.K.A Adobe Acrobat Pro End User Software Required: Adobe Reader A.K.A. Adobe Acrobat Reader When a fillable .pdf is opened in Adobe Reader and filled in, typically the end user will save the .pdf with the contents entered, then email the document to the designated recipient. However, if you are…

Upgrade Your Garage Door Opener With a WeMo Maker and Amazon Echo

How to Use WeMo Maker as a Garage Door Opener in Conjuction with Amazon Echo. Hardware Items Needed: I purchased all of these on Amazon.com for around $130 (The images below link to their respective Amazon listing) Tools Needed: Software Neded: DISCLAIMER: I make no guarantees about my documentation below. Try at you own risk….

Fargo Police Explorer Logo Design for Fargo Police Department

Approached by Officer Taylor Savageau about the reboot of the Fargo Police Explorer program, he informed me the Fargo Police Department was in need of a new logo for the program. After a few mockups, I recevied an email stating “Post #359” would needed to be included in the design. The addition of this number…

Fill a Column with a Series of Numbers in Excel

Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value in the next cell to establish a pattern. Tip: For example, if you want the series 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells. If you want the series 2, 4, 6,…

How to Save Video Streaming in Google Chrome for Local Use

You may have noticed right-mouse clicking on a video stream you’ve found on the net doesn’t allow you to save the video to store locally, whether on your desktop or on a flash drive, etc. This little Google Chrome trick will allow you to save the video file for watching later without the use of…