Categories
VBA

Hello World! Excel VBA

I find Visual Basic for Applications most useful in Excel. I have created many small enhancements to make my larger spreadsheets easier to use. Here follows a simple “Hello World!” introduction to VBA for Excel. In this exercise, we are simply going to have a pop-up message appear when we first open an Excel Workbook. […]

Categories
VBA

Display the full pathname of a Word document in the Title Bar

I have to have multiple Microsoft Word documents open when I am marking CAT practical assessment papers. As I have the Learner’s file, the original file, as well as the solution file open and they all, have the same name, it becomes difficult to know which one I am viewing. As constantly clicking on File […]