VBA vs OOo Basic Performance II
This article follows on from VBA vs OOo Basic Performance where I discussed OOo Basic performance and coding efficiency, and one of the specific issues was “how long does it…
VBA vs OOo Basic Performance
I am currently working on a HOWTO on VBA to OOB migration. As part of this I have been doing a benchmark comparison on their relative performance. The preliminary results…
Differences in Error Handling between VBA and OOo Basic
I have been looking at the difference in how OOo Basic (OOB) and VBA handle errors. I started from the basis of a whitepaper that I wrote (see Error Handling…
A Little Introduction into BBcode
BBcode is a gutted version of HTML designed to facilitate some basic formatting and enrichment of your posts on the forum, but without compromising the security and presentation of the…
The EggBlog Adventure
As I said in my About preamble, I want to have a blog-site with the primary purpose of supporting my interest in the OOo programme. However that being said, I…
An example of how to use VBA/COM over Outlook
Do you hate those pesky people that send you 7Mbyte unzipped attachments This is a little demo of the power of VBA/COM integration. At work we suffer from these bizarre…
Performance Collapse in Systems
Introduction This paper describes a macroscopic characteristic of complex systems that can result in performance collapse in seemingly random and undiagnosable ways. In recent months I have had to troubleshoot…
Error Handling in VBScript – Part III
Strategy for Handling Errors I lay out a set of guidelines in this section is that I strongly recommend that you follow if you are developing VBscripts. Rule 0. You…
Error Handling in VBScript – Part II
Interpreting the Error Code and Description Let’s look in a bit more detail at how the interpreter within the VBscript engine handles errors and how they are recorded in Err.…
Error Handling in VBScript – Part I
Introduction Over the last few months I have been sponsoring the development of a new Best Practice for the use of scripting for the automation of system administration. However in…