Remove VBA Password from Excel 2007/2010 file

Some days ago I had to improve a VBA macro but password was lost, so there was no direct way to enter code in VBE. There are a lot of tricks I found in the WWW, some of them even provide a tool. But do you trust such tools?

Beside that I found a such an easy to use instruction, »hidden« in a blog comment, I must share with you.

Continue reading Remove VBA Password from Excel 2007/2010 file

Windows 10: Remove OneDrive item from Explorer

Some days ago I installed Windows 10 which wants you to use Microsoft’s OneDrive cloud solution. Like the Windows versions before the Explorer integrates some items in the navigation area that you might not need, like the OneDive link. The Explorer itself does not provide any option to hide this item, but you can do that via registry:

Continue reading Windows 10: Remove OneDrive item from Explorer

JavaScript: transform slug to camel case

I refactor my atom packages at the moment and one thing I changed was loading classes from other files. Before, everything was hard-coded and it should be more generic, especially facing future changes. Because I used kind of slug strings internally, I created a function which converts slugs into camel case. Perhaps you need such code?

Continue reading JavaScript: transform slug to camel case

2 Packages for Atom editor: sass-autocompile & atom-minify

Since some time I switched from Sublime Text, which is an awesome editor, to Atom. The reason for this is that Atom is Open Source and I do not have to pay money for it ;) After I combed through the packages I found less-autocompile which leads me to have a closer look at LESS, and at least at SASS too.

This was the start for me to develop Atom packages, I want to introduce here! For more information about the particular package, have a look at the corresponding readme and try it out :)

Continue reading 2 Packages for Atom editor: sass-autocompile & atom-minify

jQuery: missing method toggleAttr for toggling attributes

Today I needed some JS-Code for toggling an DOM elements attribute. Because there is no such feature in the jQuery core, I implemented it. Perhaps it’s useful for you, so here it is :)

Continue reading jQuery: missing method toggleAttr for toggling attributes

Atlassian Bitbucket Server/Stash: What to do after Java update?

Update, 20.10.2016I updated this article because Atlassian has updated Stash and renamed it to Bitbucket Server. The first part is the old article about Atlassion Stash and the second part includes the latest Bitbucket Server including ElasticSearch.

Atlassian Stash

Today, another Java Update has been released, so I installed the new version und removed the old one. The “problem” was, as with the last updates, that I had to tell my Stash installation where to find the new Java version. I opened the Windows registry and updated the following three registry keys:

Continue reading Atlassian Bitbucket Server/Stash: What to do after Java update?

Clone/migrate Microsoft Windows from HDD to SSD – with Knoppix and dd command

Some days ago I received a 256GB SSD for my Server in which I used a normal 500GB HDD for Windows installation – booting process needed about 5 minutes so it was time for this step ;) Because many services, like Active Directory, Oracle Database or Atlassian Stash, running on this machine I did not want to reinstall and reconfigure everything from scratch, so I looked for tools and easy possibilities to clone/migrate my server installation. And here is my solution which worked really well and is totally free!

Continue reading Clone/migrate Microsoft Windows from HDD to SSD – with Knoppix and dd command

Images for Lenovo 0B47202 ThinkPad Compact USB Keyboard German

Today I received my new keyboard Lenovo 0B47202 ThinkPad Compact USB Keyboard. When you are looking for images of exactly this keyboard, you you only find images of the english layout, not the german one! Well, I have not found at least one image… That’s why I made some photos, perhaps someone needs them for product presentation or something similar, or only wants to see how the german layout looks like!

Continue reading Images for Lenovo 0B47202 ThinkPad Compact USB Keyboard German

Atlassian Bitbucket Server Backup Client: script for running backup as Windows task – Version 0.10

I have written a script for running Atlassian Bitbucket Server Backup Client as a Windows task on my server. There are two main reasons/features why I created that script and why I want to share it.

Continue reading Atlassian Bitbucket Server Backup Client: script for running backup as Windows task – Version 0.10