Posts

Last month I picked up my new “do it all” gravel bike and will be uploading my initial review and thoughts on that, I took the decision to sell the Boardman URB 8.8 that I picked up last year as I’ll not use it as much and the demand remains pretty high. I had listed the bike on Facebook Marketplace and while I had no shortage of interest there were no serious buyers, I received a message from someone in Leeds who was keen to purchase the bike at asking price and cover any delivery costs....

Overview So earlier on this week I took delivery of a new Alienware M15 R5 laptop, it’s the first Alienware laptop with an AMD Ryzen processor and this peaked my interest. Like most gaming laptops, it comes with two PCIe M.2 slots for adding additional storage. Upon delivery I opened the laptop and was surprised to see that whilst there was a vacant M.2 slot for the additional storage the laptop didn’t provide a standoff to screw it into....

Recently moved to a new street and can’t update the address of your driving license online with the DVLA? It isn’t obvious but there is a workaround. Below is an example of what you may see when changing your address. If like me you clicked “Other ways to enter your address” and got nowhere? You don’t need to do this. Simply remove the house name or number and enter a valid postcode, any postcode at all....

This guide walks through the process of fitting a VW RCD330 Plus to the Seat Leon MK2. The reason I picked this radio is that it’s a direct (Almost – keep reading) fit to the MK2 Leon. It uses the existing wiring, illumination matches the original in the car and the steering wheel controls will work too. Note that this applies to my 2012 Facelift Leon 1P, I believe the pre-facelift models (2005 – 2009) may be a little different....

Introduction First point to note, this post is aimed at F20/F21 owners as that is what I have completed the procedure in – this is also possible on the F22 (2-Series) and F30 (3-Series). My understanding is this, when ordering the EBT package with your car (Approx £400) it’s fitted with a Combox which provides the functionality along with enabling the feature in the iDrive. Good news if you have BMW Professional Navigation or a 2014 (See note) model – your car will have a Combox and armed with the tools below (Less than £10) you can enable EBT....

A number of years ago I uploaded a short video on YouTube that shares a VBA script that can quickly convert accented characters within Excel cells into “normal” characters. I used this for a data migration project, maybe you’ll benefit from it also? Within your Excel document hold Alt and press F11. Select Insert > Module. Copy and paste in the code below. Function StripAccent(thestring As String) Dim A As String * 1 Dim B As String * 1 Dim i As Integer Const AccChars= "ŠŽšžŸÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ" Const RegChars= "SZszYAAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy" For i = 1 To Len(AccChars) A = Mid(AccChars, i, 1) B = Mid(RegChars, i, 1) thestring = Replace(thestring, A, B) Next StripAccent = thestring End Function Close the VBA window....