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....
Introduction Each year thousands of people are exporting/importing exotic cars between various countries, I’ve always fancied owning a Honda Integra Type R (DC5) which were never sold natively in the UK but knew little about the process and costs involved. People do import them here to simply sell on with a little markup on top, but they demand a premium especially in recent years. Japan as an export location is a favourite for drivers in the UK as Japanese cars are right hand drive as they drive on the left hand side of the road....
Over the last few years I’d seen many posts from Vitality promoting their Apple Watch deal. I don’t remember the specifics but I do recall it appearing to be an attractive option and as someone who likes wearable technology and keeping fit I was interested. People often ask me how it works and going forward I’ll send them a link to this post. Hello! 👋 Important – Do you have a Vitality policy?...
Beeline is a small company based here in the UK that have created devices to make navigation easy whilst cycling or riding a motorcycle. A colleague of mines purchased the Beeline Moto and said good things about it, they also offered a Velo for cycling. Last week (7th June 2022) the second iteration of their Velo device went on sale. At the time of writing (18th June 2022) the device can only be purchased directly from Beeline themselves at a price of £79....
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....