Understanding the VBA Editor

VBA has an easy-to-use interface called the Visual Basic Editor (VBE). In order to access the VBE, you first need to display the Developer tab. To show the Developer tab,  open a 2007 Office System application, for example Word 2007. Click the Microsoft Office Button, and then click Word Options. In the Top options for [...] . . . → Read More: Understanding the VBA Editor

VBA/VB Recursing Through Nested Directories

I wrote a post about iterating over a directory with a Dir loop awhile back and I just received an email asking about nested directories. I’m a big fan of nice, big flat directory structures, but I frequently run into nested data as well. Here’s a VB6 snippet to traverse a directory structure recursively. Keep in [...] . . . → Read More: VBA/VB Recursing Through Nested Directories

Creating a WordPress Import File with Excel

WordPress Import Files Using Excel
Disclaimer: I absolutely do not advocate splogging of any kind. This is simply a way to get your existing data into a WordPress blog. This same method could be used for chapters in book, recipes, or whatever other kind of data you may have. Rather than taking the monumental effort of [...] . . . → Read More: Creating a WordPress Import File with Excel

Text File to String VB Function

Here is a quick little VB/VBA function to turn text files (or html files or xml files) into string variables.
Text File to String Variable Function (xml file to string variable, html file to string variable)
There are numerous Internet Programming situations where large pieces of text need to be populated with variable values. On other occasions [...] . . . → Read More: Text File to String VB Function

Iterating over a Directory with a Dir Loop (Loop Through Directory) VB

VBA is potentially the greatest desktop ‘hammer’ you have at your disposal. You can pop open any Office application, hit ALT+F11 and be writing code before Visual Studio will even be open on most machines.
For doing ad hoc work around the office, VBA allows you to do things that applications alone simply aren’t powerful enough [...] . . . → Read More: Iterating over a Directory with a Dir Loop (Loop Through Directory) VB

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 [...] . . . → Read More: Real World Scenario using Word Templates

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 [...] . . . → Read More: Uniform Credit Write-Up – Large Sample Automated Word Template (.dot)

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 [...] . . . → Read More: Fee Credit Calculator – Need for a VSTO Solution

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 [...] . . . → Read More: VB MazeMan

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, [...] . . . → Read More: Three Types of VBA Errors

Sponsors