Call Us At: 701.866.2098

Category: <Coding with Coffee/>


Command Prompt: Deriving UNC Network Path

Here’s the workaround I see many using when sending mapped-network paths via email: In Windows Explorer, hold the shift button down, right-click on the file, and select Copy as path. Insert a Hyperlink in the email and paste in the address field of the Hyperlink dialogue box. (Shortcut: Ctrl-V). At this point, the link will…

How to Create Dummy Files with Windows Command Line

Fsutil.exe is a built in filesystem tool that is useful to do file system related operations from command line. We can create a file of required size using this tool. fsutil file createnew filename length (length is in bytes) For example, to create a dummy file test.txt, with size as 50MB: Note: The above command…

Acro JavaScript: Folder Level Script for Save As PDF

Have you ever needed to submit a PDF to a specific file path, but couldn’t figure out how to accomplish this? Let’s do it! Here’s how the file name will appear when the users selects the submit button in the form in this scenario. Here’s the JavaScript placed on the submit button in the PDF:…

Acro Javascript: Placement Text in PDF Form Fields

In addition to the post: Acro Javascript: Question Icons / Buttons an additional way to include instruction to users who may have questions when filling out more complex forms is to use placement text within the form fields. Here’s how the PDF could function: To do this, start by opening a PDF form. Select the…

Acro Javascript: Question Icons / Buttons

PDF fill-able forms are no new concept when it comes to electronic forms. Though these electronic forms are great for allowing users to submit information digitally via email, some forms may be a bit more complex then others. This can cause confusion for the intended users and ultimately the submission of forms filled out incorrectly….

Automate Significant Changes to PDF Documents with Actions and Macros

Software Needed: Adobe Acrobat DC, Microsoft Word Tasked with making multiple changes to PDF documentation, I decided to automate the system rather then going through each document to update/save accordingly. Essentially I was given 163 PDFs that required updates to verbiage and date periods, as well as the replacement of the last two pages of…

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…