Life…as it relates to Technology.

Posted on June 26, 2009 by scott

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 [...]

Posted on June 17, 2009 by scott

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 [...]

Posted on June 17, 2009 by scott

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 [...]

Posted on November 09, 2007 by scott

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 [...]

Posted on November 03, 2007 by scott

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 [...]

Posted on November 03, 2007 by scott

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 [...]

Posted on November 03, 2007 by scott

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 [...]

Posted on July 31, 2007 by scott

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, [...]

Posted on December 31, 2006 by scott

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 [...]