Fitting Sync 3 to my 2015 UK MK3 Ford Focus

In this post I’ll step through how to swap out the dated Ford Sync 2 for the much improved Sync 3 infotainment system on my MK3.5 Ford Focus in the UK! At the end of last year I picked up my 2015 Ford Focus ST-3. The infotainment system on it looked great on paper! It came with a 8″ Touch Screen Display, Satellite Navigation, Bluetooth Calls/Audio, Reverse Camera and a USB Audio Interface....

February 2, 2024 · 5 min

Fitting the Passat Climate Control to MK6 Golf

I’m writing this quick post following a request from users on Facebook and Reddit. I’m not the first to conduct this modification and take no credit, but hope publishing this information will be of use to others. If you have a Volkwagen Golf MK6 with the dual zone digital climate control as seen below in my “Before” photo, it is possible to swap this out for the Passat B7 unit which features digital screens....

April 9, 2023 · 2 min

Alienware M15 R5 SSD Bracket

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

October 2, 2021 · 2 min

Update driving license address with DVLA for a New Build House

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

January 7, 2021 · 1 min

Fitting VW RCD330Plus to Seat Leon MK2

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

February 10, 2019 · 3 min

Enable Enhanced Bluetooth on BMW F20 & F21

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

January 23, 2015 · 4 min

Quickly Convert Accented Characters in Excel

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

July 29, 2014 · 1 min