E-Mail:

General

Microsoft Jet Text Driver and Excel

Using ADO and Jet Microsoft offers a way to view a folder, containing delimited text files, as a database where each file is a table.
The perspectives in this are great; you can perform joins, filtering, aggregation etc. without resorting to parsing techniques - you get to write sql queries instead!
In the example below I demonstrate [...]

Extract time part from VBA date

In a project at work I use Excel to perform analyses of some data records, which are timestamped by date and time.
I want to categorize the records by their time-of-day eg. “morning” and “afternoon”.
For this I define what is the beginning and end of each category eg. “morning”: from 07:00 to 09:00.
To find the category [...]

Google Chrome And Symantec Endpoint Protection Fixed In MR3

Google Chrome has until recently been clashing with Symantec Endpoint Protection (SEP), making it impossible to run Chrome in sandbox mode. It was possible to disable sandbox mode by running chrome with the argument –no-sandbox. Ironic, really, considering both SEP and sandbox mode attempts to protect the user from malware.
On behalf of a company, which [...]

Google Chrome And Symantec Endpoint Protection Fixed In MR3

 
Google Chrome has until recently been clashing with Symantec Endpoint Protection (SEP), making it impossible to run Chrome in sandbox mode. It was possible to disable sandbox mode by running chrome with the argument –no-sandbox. Ironic, really, considering both SEP and sandbox mode attempts to protect the user from malware. 
On behalf of a company, which [...]

Language spaghetti - what’s your favorite?

The programming world has come a long way since Donald Knuth made his arguments for limited use of go-to statements.
People are starting to think less about execution speed and memory consumption and more about readability and conciseness. Scripting languages are being used more and more for the following reasons, among others:

We don’t want to compile [...]

Find and delete empty directories

I had iTunes “help” me organize my musik for a while. Now I’ve abandoned it for this reason, among others (e.g. it’s terribly slow and playback stutters).
I’ve used http://musicbrainz.org/ products to clean up the mess, but only to be left with a bunch of empty directories (thanks again, iTunes). I wrote up this ruby script [...]

PPTPD setup for home networks

I managed to get the poptop aka pptpd server running to my content today.
I have an Ubuntu server at home, which I would like to access from the internet side. I mostly use Windows machines, which natively support pptp connections so the choice of poptop was obvious. A good alternative would be OpenVPN, of course.
First [...]

Windows network confusion

Hi
I am playing around with a poptop box on an Ubuntu server at home. While testing the connection to the VPN server I got this very interesting result when pinging the IP, which was assigned to me by pptpd:
C:\>ping 192.168.0.210

Pinging 192.168.0.210 with 32 bytes of data:

Reply from 192.168.0.210: bytes=32 time=4ms TTL=128
Reply from 192.168.0.210: bytes=32 time=-4ms [...]

Transform ruby array to tex table

This has probably been written in many projects, anyways here is the code I wrote up to convert a ruby table / 2-dimensional array / array of arrays to a tex table:
def to_tex(table, user_opts = {})
default_opts = {:center => true, :sep_cols => true, :col_align => ‘l’}
opts = default_opts.merge(user_opts)
lines = [...]

Firefox File Links Take 2 - URL Protocol Handler

Update 15-12-2007: for smb links, I noticed that the handler would throw an error message when a login to the server hosting a resource had not yet been done regardless of the existence of the resource. I changed the handler so that it will try to open the resource in explorer if it is not [...]

19 queries / 0.114 seconds.