Quickly merge Excel files, spreadsheets or tabs with VBA

By Jan-Willem Bobbink in Miscellaneous 10 Comments

Sometimes you just need to merge hundreds of Excel files into one. For CSV files you can easily use the Command Prompt, for Excel you’ll need some VBA scripting. Working with many individual files can be time consuming so use below VBA scripts to merge individual XLS-files into one or combine multiple tabs into one sheet. Simply go to the Visual Basic Editor (Alt / Fn + F11), add a new module and run the script. An easy to understand tutorial can be found at The Excel VBA editor.
Continue reading

The danger of content marketing for SEO

By Jan-Willem Bobbink in Miscellaneous, Technical SEO 2 Comments

google-panda-updateMany articles have been written about content marketing in the past years, online marketers are sometimes completely obsessed about content marketing. Because of several projects I did during the past 12 months and all those people using “Content is King” whenever possible, I would like to discuss some of the factors content marketing has an impact on. These factors are not commonly considered by everyone involved in online marketing campaigns.

Due to the fast-paced development of Google, where there has been more focus on the quality of content and websites by developing algorithmic filters like Panda, many websites have produced enormous amounts of textual content on their domains. A lot of websites are still targeting specific queries with unique pages instead of targeting a specific group of people. In the company of the latest updates of Google’s algorithms, where Panda is one of them, some problems start to occur. From a technical point of view, more content is not always positively influencing the organic results.

Continue reading

How to disable the Bing Translator on Twitter

By Jan-Willem Bobbink in Miscellaneous 0 Comment

annoyedSo Twitter decided every tweet should be translated by default. Even if your Tweet is in English, they have it “translated” by Bing. I find it really annoying, and looking to all the buzz on Twitter, I’m not the only one. 🙂

There are several solutions, the most easy one you can use is an Adblocker and adding the following URL: https://twitter.com/i/translations/*

I prefer to use Adblock Plus which can be used for Firefox, Chrome, Android, Opera, Safari and Internet Explorer

For iOS users, you could try to block the same URL, via the following method iOS 7: How to Block Specific Websites and Group Shared Links On Safari

For people using Google Chrome, you can use the following plugin: ExtensionDisable Bing Translator on Twitter.

(Image credit; unknown since copied to thousands of websites without mentioning a source :))