Call Us At: 701.866.2098

Category: Visual Basic


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…