Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Tutorials     Bits and Bobs     Word     PHP     Odds and Sods     Browsers     Utilities     Flatpress     Excel         Windows     Bookmarks     Plausible Lies     VBA     Hardware     Equipment     3D Stuff     Overcoming Disabilities     Reviews     News     Acrobat     Family     Software     Education  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

How to crack the password on an Excel VBA Project

Permalink: http://paul.us2uk.eu/?x=entry:entry170809-124855

I never set passwords on my VBA Projects. Initially this was out of pure laziness but they’re not secure anyway so setting one is pointless if the sole reason for setting one is to keep your code a jealously guarded secret.

Now, there are legitimate reasons why you might want to crack a VBA Project password and I recently needed to do just that on one of the workbooks in our office which was causing the user a problem when trying to copy and paste from one sheet to another: when the user selected a different tab they also “lost” whatever was on their clipboard so they couldn’t do the usual thing of selecting a cell in the sheet where they wanted to paste something when the “Select destination and press ENTER or choose paste” message appeared at the bottom, because this message disappeared when they selected a new sheet.

There was obviously some script being triggered when they selected this sheet and, if you carry out any operation on a sheet before you get chance to paste your information in, then that chance goes begging.

Unfortunately this particular workbook was one they’d inherited from a user who had long-since left the company and the VBA Project had been locked with a password to protect the code… but no-one knew the password.

Of course there are solutions out there which you can download or buy but, if you’re already comfortable with VBA (otherwise why would you want to get in there to fix things?) then here’s an easy solution which works for all versions of Excel, both 32 bit and 64 bit.

https://stackoverflow.com/a/27508116

Make sure you click the link (or scroll down the page) to see the corresponding code for 64 bit versions of Excel (you need to use the code which applies to your version).

Credit for this solution goes to Duc Thanh Nguyen.

The basic instructions are that you copy the code given into a new workbook, save that with whatever file name you want, then leave the workbook open.

Switch back to your workbook with VBA password protection enabled and click on the Developer tab, then Macros, and choose to run the macro called, simply, “unprotected” which should pop up a nice friendly message like this:

VBA Project is unprotected message box

Cropping & converting MP4 Files to other video formats

Permalink: http://paul.us2uk.eu/?x=entry:entry170715-125101

I recently had a small success which made me go “yeh!” and I happened to find this neat intro to a 1960 western serial featuring my name which kind of summed up how I was feeling at the time :D

Download video: MP4 format | Ogg format | WebM format

The problem was that I could only download the full episode in MP4 format so I needed to crop the video just to get the intro into a much smaller file.

Not being one for downloading over-hyped and bloated software I remembered I had a very good little MP4 Joiner (to stitch mp4 files together) on my computer so went looking to see if they had a splitter too - and so they did:

http://www.mp4joiner.org/en/

The joiner and the splitter are now bundled together in one installation file called Mp4Tools, but they work great and are simplicity itself to work out how to use them.

Just one word of warning - while the latest file you can download at the above link installs and works just fine I did have a problem opening the splitter application when I tried to install it on my old Windows XP computer, so I installed the older version 3.0 of the software on that machine, and that worked without a hitch.

In case you have any trouble running the latest version of the sofware you can find the older versions here. Just choose the version 3.0 EXE file and you should be ok:

https://www.videohelp.com/software/MP4Joiner/old-versions

Now that I have the intro of my video nicely cropped I can either make and animated GIF of it or share it on the web, as I’ve done here, but I needed to convert it to a couple of extra formats in order to ensure that the video played in as many browsers as possible.

The formats I needed were .webm and .ogv (OGG format), and instructions for embedding the videos after first uploading the files to your web space can be found here:

http://camendesign.com/code/video_for_everybody

However, you don’t need to really understand how to do this as you can save much time by using the handy code generator which they’ve provided here:

http://v4e.thewikies.com/

In order to covert my MP4 file into these 2 formats I used the following online converter which was quick and very easy to use:

http://video.online-convert.com/

The above website has converters for all sorts of different types of file (e.g. Office documents too), so it’s well worth bookmarking.

Drawing version comparison made easy

Permalink: http://paul.us2uk.eu/?x=entry:entry170711-120251

Back in the olden days (when the internet was in short trousers) I used to create animated GIFs for my web pages using a great little program called Microsoft GIF Animator.

It’s somehow gratifying to learn that this great and tiny application is still available and runs flawlessly on my 64 Bit Windows 7 computer and I recently used it to compare old and new versions of a drawing, to easily see what’s been changed…

Using an animated GIF to compare drawing versions

Of course, this technique can be used for may other purposes - and it’s really just a variation on how astronomers use a blink comparator to detect movement of celestial bodies through the relatively fixed background of stars.

Microsoft GIF Animator is a single standalone file - no installation required - which is very easy to use. The hard work is getting your comparison files to be the same size and have the features all line up, but this is quite easy to do when working with drawings.

You can download the file here and also see some basic instructions, but the program comes with a built-in help file which which tell you all you need to know to get started.

Also here is a web page with an easy to follow tutorial:

http://gwanderson.server101.com/Computer101/gifAnimate.htm

Animated GIFs aren’t difficult to do, and you don’t need to use some “magic” online generator to make them because this old Microsoft program will let you create some very complex animations, once you get to know it.

No more war no more war no more war

Permalink: http://paul.us2uk.eu/?x=entry:entry170620-013718

This is the original version of the song which helped make a star out of Sade:

Timmy Thomas - Why Can’t We Live Together

Where are all the protest songs now.. and I mean protests about the real stuff going down in this world, and the real causes?

Hint: it’s not Donald Trump, muslims, or “equality”. It is however agenda-driven and media-led… whether those sock puppets who masquerade as journalists know it or not.

Eleven years ago

Permalink: http://paul.us2uk.eu/?x=entry:entry170618-132536

Duke Gildenberg was on television…

Duke Gildenberg on British TV 10th June 2006 at 18:37 GMT

So, why was Mr Gildenberg on TV? Where does he fit in to world history?

image When Joe Kittinger made his world-record jump from 102,800 feet on Aug. 16, 1960, as part of Project Excelsior, launch couldn’t even take place until one man gave thumbs up. “Our forecasts were provided by one of the best meteorologists in the Air Force…: Bernard ‘Duke’ Gildenberg,” Kittinger wrote in “Come Up and Get Me” (UNM Press/2010, with Craig Ryan). “If Duke said go, you went, or you’d wonder why you hadn’t.”

http://www.spacesafetymagazine.com/aerospace-engineering/red-bull-stratos/balloon-go-no-go-gildenbergs-call-part-1/

Bernard David Gildenberg or “Duke,” as he was known in New Mexico and at NASA, was born in Hazelton, Pa., in 1925. He was brought up in Brooklyn, N.Y., and had lived in La Luz and Tularosa for the last 60 years of his life. He was a graduate of New York University and was in the Air Force during World War II, stationed in the Aleutian Islands in Alaska.

Mr Gildenberg died on the 2nd April, 2013, of natural causes.

Food Mixer and Back Door - June 2006

Oil does not come from dead trees (or dinosaurs)

Permalink: http://paul.us2uk.eu/?x=entry:entry170303-215520

You don’t believe me?

Well how do you explain the fact that Saturn’s largest moon, Titan, holds more oil & gas than all the known reserves of the Earth?

http://www.space.com … titan-oil-earth.html

There’s a lot to be said for the idea that the earth’s oil pockets are self-replenishing. It wouldn’t do a great deal for the price of oil if word got out that there are trillions of gallons of the stuff sloshing about way down deep in the Earth’s mantle, ready to slowly seep back up and fill the voids which we’ve so far managed to suck dry.

We’re NOT running out of oil folks!

The fish were looking at me - Stanley Oliver

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-203107

They had that look that said…

“We can see that you’re sat over there with nothing to do…

so how about giving us our food a little earlier tonight?”,

and do I did

Stanley Oliver 1828

The Collected Works of Stanley Oliver - The Partridge Press 1945

Do trees shiver? by Stanley Oliver

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-200900

It seems odd that trees, if you observe them closely, only sporadically drop their leaves, and do so in unison with all the other trees around them… almost in symphony with one another - even when there is no wind at all.

Perhaps some highly expensive apparatus could detect, record, and analyse the precise barometric and climatic conditions in fine enough detail in order to determine any correlation with the trees dropping their leaves.

If not, then there is something else going on.

Stanley Oliver 1841

The Collected Works of Stanley Oliver - The Partridge Press 1945

I was awake - Stanley Oliver

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-184325

The rain fell lightly, but steadily, all through the night.

In its wake the road to the headland took on a sheen of sheer silver.

It was then, I knew, I was awake.

Stanley Oliver 1823

The Collected Works of Stanley Oliver - The Partridge Press 1945

For Once in my Life (Extended Version) - Stevie Wonder

Permalink: http://paul.us2uk.eu/?x=entry:entry170128-173546

Want one!

Permalink: http://paul.us2uk.eu/?x=entry:entry161229-004337

A South Korean company has unveiled a prototype for the world’s first manned, two-legged robot. It’s 4m High!

When it came up with “Potential uses” on the video I thought the first one should be to fight other 4m high robots!

I wonder when we’ll ever see the first manned walking robot on the moon?

http://www.bbc.com/news/technology-38442672

image

Excel Functions - Version Compatibility

Permalink: http://paul.us2uk.eu/?x=entry:entry161117-162809

While working on a spreadsheet today I was using the ISERROR function to test if a VLOOKUP formula returned a value and, if it did, return the value otherwise display nothing - instead of the usual #N/A error notification.

The usual syntax for this formula begins “=IF(ISERROR(VLOOKUP(…”.

I happened to notice that Excel 2010 (the version I use at work) offered up “IFERROR” as a possible function as soon as I typed the “IF” and, indeed, this allows me to write slightly shorter formula. However this is not backwards compatible with Excel 2003 which I use elsewhere so I avoided using it.

For anyone faced with a situation where they have a spreadsheet containing lots of instances where the a formula contains “IFERROR” then help is at hand at the following link - untested, but I’m sure it’ll work. I’ve bookmarked it here because it looks like quite a useful site.

http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/

There are obviously a few more functions which were added in later versions of Excel which you should avoid using if you don’t want your spreadsheet to fail when someone opens it in Excel 2003 (which I much prefer!). The other one I avoid for this reason is “SUMIFS” (I use “SUMPRODUCT” instead) but here’s a useful list of all Excel functions showing which versions they are compatible with - plus a useful description of each..

https://docs.google.com/spreadsheets/d/1ztUAhgAghKn2wNih7-QgMbSAKfux4w_qkAcJdD82bLU/edit

Here’s the same thing downloaded for posterity as an XLSX file

Windows 10 Update Freezing Computer

Permalink: http://paul.us2uk.eu/?x=entry:entry161107-001648

Windows 10 Logo When a monster update came through and installed itself on our Windows 10 laptop,  aside from suddenly getting annoyed to death by “Cortana” (some stupid Microsoft “help thing”, I think - not asked for nor desired, anyway) the laptop - a Dell - just started freezing up after a few minutes of use.

If this happens to you (and you could care less about ditching Cortana) then try this first before tearing your hair out. [Read More…]

Fix for Windows 10 Can’t Connect To This Network

Permalink: http://paul.us2uk.eu/?x=entry:entry161025-233719

The solution to this extremely annoying recurring problem which worked for me was this:

[Read More…]

Merging cells in Excel can lead to formula errors

Permalink: http://paul.us2uk.eu/?x=entry:entry160930-180600

As I’ve just discovered after so many years of using Excel if you merge a group of cells and then use a lookup (I only ever use VLOOKUP but it will probably apply to HLOOKUP too) to return the value from that merged group of cells, then you run the risk of getting the wrong result.

Here’s why, and why you should NEVER use merged cells in part of your spreadsheet which you might (one day) want to look up date from via a formula…. [Read More…]

What’s the crake?

Permalink: http://paul.us2uk.eu/?x=entry:entry160901-190400

I feel somewhat vindicated in my stance that the correct term for “good banter” in Ireland and Britain is “crack”, not “craik”, and not “craic”.

http://www.scotland.com/forums/language/15676-craik-crack.html

It seems that the correct spelling was and will always be “crack”.

The so-called Gaelic spelling (craic) is a fairly recent introduction and is not a Gaelic word at all, it is purely an attempt to make a Gaelic-sounding word out of the original - perhaps because of the narcotic connotation of the correct spelling or maybe just because too many people from the old country want to sound like they’ve just stepped off the steamer from Queenstown.

I’m sure it will continue to be used in all of the thousands of “Irish Bars” which are dotted around the world and will, eventually, be pronounced “crake”.

So there you have it.

Fix for no audio/sound via HDMI

Permalink: http://paul.us2uk.eu/?x=entry:entry160829-132605

I have a recurring problem with my media PC dropping the HDMI audio output to my big Sony TV - and I keep forgetting how to fix it (because it’s quite a simple fix but it’s not that obvious how to do it).

Why this happens is anyone’s guess but, for some reason, the TV gets disconnected or disabled somehow - AND THEN HIDDEN in the choice of speakers when you click in the speaker icon in the system tray (where the clock is).

Here’s where I refreshed my memory but, although this says it is for Windows 10 it does also work just the same in Windows 7, which is what I have installed. You may find some additional solutions there, if this doesn’t work for you:

https://www.drivereasy.com/knowledge/fix-hdmi-monitor-has-no-sound-after-windows-10-upgrade/

I knew I had to right-click somewhere and get the Plackback Devices panel to show my TV as an option but I couldn’t remember where. Well, all you need to do is RIGHT click on a BLANK AREA of the panel (right-click on the speaker icon then choose “Playback devices” to show the panel, then see the picture below) and then make sure that both “Show Disabled Devices” and “Show Disconnected Devices” are checked.

This continues to solve the problem for me. I hope this has helped you too!

image

Find and Replace Line Breaks in Excel

Permalink: http://paul.us2uk.eu/?x=entry:entry160812-105344

One of the most frequent things I forget how to do is the replacement of line breaks in Excel cells. You can put a line break in an Excel cell simply by pressing Alt+Enter while you are typing in your data, but sometimes you want to replace some of the text PLUS the line break.

To do this is equally simple (once you know how) just by entering Ctrl+J so say you have a cell with the following data with a line break in it:

ABC
XYZ

and you want to either replace or even remove the top or bottom line you would go to your Find & Replace dialogue box (press Ctrl+H) to bring this up and then enter either of the following in the “Find what:” box…

To remove the top line type “ABC” then press Ctrl+J (it will not actually show anything because the Find what box is only one line high, and you might just be able to make out the top of the insertion point I-bar cursor flashing below the A), then type in whatever you want in the “Replace with:” box - or just leave it blank if you want to delete that top line.

To remove the bottom line first press Ctrl+J THEN type “XYZ”. In this case you might not see anything when you type the “XYZ” except (again) the flashing top of the cursor moving along as you type the letters on what a line which is hidden by the restricted height of the “Find what:” box.

Thanks to Debra Dalgleish for this excellent tip ever at her equally excellent Contextures Blog…

http://blog.contextures.com/archives/2013/05/28/find-and-replace-line-breaks-in-excel/

Dad’s Army Story - Victoria Wood

Permalink: http://paul.us2uk.eu/?x=entry:entry160425-005228

Dad’s Army Story

I don’t know Jack

Permalink: http://paul.us2uk.eu/?x=entry:entry160415-143737

David Lynch funded this documentary about the star of possibly the strangest, most intensly photographed film I’ve ever seen.

https://www.youtube.com/watch?v=-cSZvOyZNtU

A documentary about Jack Nance, star of the David Lynch film “Eraserhead”

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.