Real World Scenario using Word Templates
Merrill Lynch Business Financial Services developed an extensive Word template repository programmed in VBA. The repository consisted of a single network folder that housed over one hundred stand-alone Word templates. Each template launched a userform when invoked that prompted the user for basic information. This information was then used to populate certain areas of the [...]
Uniform Credit Write-Up - Large Sample Automated Word Template (.dot)
One of my earliest projects involving Word began as a simple task to create internal “credit write-ups” (write-ups) for a banking institution. These write-ups involved a detailed analysis of the credit worthiness of businesses that were applying for lines of credit and term loans. The write-up contained various sections: business information, guarantor information, collateral description [...]
Fee Credit Calculator - Need for a VSTO Solution
I was involved with a project to create a complicated “Fee Credit Calculator” for a large financial institution. The basis of the project was that large institutional clients paid enormous fees for certain mutual fund transactions. There was a certain set of criteria that, if met, entitled these institutions to a partial refund of the [...]
VB MazeMan
I put this “Visual Basic MazeMan” application together for a job interview once upon a time. The job was bogus and I could never bring myself to look at the code again. The requirements have changed - specifically saving data in binary format - as opposed to text if you are using this for any projects. Good Luck.
Download [...]
Three Types of VBA Errors
Generally, there are three types of errors that you will encounter when you are writing code: syntax errors, logic errors, and run-time errors. Each type of error requires a different means of troubleshooting. Following is a brief description of each type of error.
Syntax Errors
Let’s start with the easiest type of program error to deal with, [...]
VBA Error Handling
In a perfect world, there wouldn’t be a need for VBA error handling code at all. The reality is that it doesn’t matter how careful you are when you write your code; undoubtedly, you will have errors. If an application doesn’t handle errors in a professional manner, users will become frustrated, even if the application [...]
