Force macro-enabled documents to not display warning after opening

If you work with macro-enabled documents in Microsoft Office and you run on default settings, each such file will be always opened with macros disabled and you’ll have to click Enable macros each time to enable it. If documents are your own, you trust, that they contain no malicious code and they’re all stored in a secure location (i.e. not in some temporal or shared folder), you can change each Office program settings to have these files always opened with macros enabled.

Read More “Force macro-enabled documents to not display warning after opening”

Changing default icon for a file type in Windows 7

Windows XP was the last Windows system to have File Types tab in the Folder Options applet and to allow user easily changing default icon for particular file extension. This tab was replaced in Windows Vista and following systems by Default Programs applet from Control Panel. It lacks many features, including changing icons for file types. Therefore, in Windows systems following Windows XP you have to either use 3rd party software for achieving this simple task or dig in Windows Registry. This isn’t that hard task as it seems, so read on, if you want to give this method a try.

Read More “Changing default icon for a file type in Windows 7”

No contacts on Windows Mobile after adding Google account

If you have just purchased new Microsoft Lumia phone (or any other device, that uses Windows Mobile system), added your Google account to this device and you found out, that even though synchronization was successful, you have absolutely no contacts imported, then you’re in the same situation, as I was and this article should help.

Read More “No contacts on Windows Mobile after adding Google account”

Error 1618 when installing any software on Windows

You can find this error during for example Skype or Java Runtime Environment installation. And probably many more. It just means that another program’s installation is in progress and current one can’t continue.

It happens in most case, when you try to install some software, when Windows Update is installing heavy portion of updates. And current program can’t install or update some system elements, that are being updated by Windows Update in the same time.

Solution? Wait some time (until end of Windows Update process?) and then restart installer of your program.

Offline installer for Microsoft Office 2010 and other products

Microsoft has changed offline installation policy and you can’t download any offline installer, until you don’t provide your product key and you don’t login with your Microsoft account. If you don’t have it or you don’t want to use it, then the only option, you’re left with is to download offline installer from unofficial sources.

Read More “Offline installer for Microsoft Office 2010 and other products”

Making Windows 8 at least usable

Microsoft is a sinusoid, when talking about Windows releases. It always has perfect system followed by a total mistake and nightmare.

Since Windows 7 was a nearly-perfect system (thousand times better that Vista-joke), then we could expect, that Windows 8, that follows it, will be a nightmare, joke and a total mistake. It is.

While we’re waiting for (hopefully “perfect”?) Windows 9, we need to do something to make Windows 8 at least usable. Because, out-of-the-box, this system isn’t usable and is the shortest path to permanent mental illness. If you can avoid Windows 8, then do it, without asking why. If you’re forced to use it, this article should be a start point for restoring your mental stability.

This is rather a check-list (with some coment), what you should do or at least consider, than fully featured article. And, yes! Everything, what is written here, was tested on Windows 8.1, so should work just perfectly on both Windows 8 and 8.1.

Read More “Making Windows 8 at least usable”

Invert non-consecutive data column in Excel

Let’s say, that you have a one or more columns, in which you would like to invert data. What is most important — data does not follow step-by-step (in which case you’d use simple data sorting function in Excel), It can have something like –1, 5, 76, 23, –65, 124 in each following row of column and you want it to have like 124, –65, 23, 76, 5, –1. How to do this, if you deal with hundreds or thousands of rows, so manual change is not an option?

Read More “Invert non-consecutive data column in Excel”

Change prompt and enable command auto-completion [updated]

I really like some simple extensions and changes to command line in Linux. An ability to enable command auto-complete, commands history navigation and changing prompts look in particular.

However, not every console is suited with these changes, so I wrote this simple article to keep all my how-tos around Linux command line in one place.

Read More “Change prompt and enable command auto-completion [updated]”

Remove Shared Folders Synchronization from context menu item

There are several ways to get rid of Shared Folders Synchronization item from context menu (right-click menu) in Windows. They all depends on version of your Windows or Microsoft Office (responsible for adding this) and level of your computers skills. This post started as a quick example of removing this nasty context menu item, but ended up as a list of solutions, that you can use to remove many things that may slow down your computer. Consider reading this, even if you don’t have Microsoft Office, but your computer seems to be too slow.

Read More “Remove Shared Folders Synchronization from context menu item”

Convert NTFS to FAT32 without loosing data

There are many irritiating nerds, on many forums and websites, claiming or tryiny to convince you that their belowed piece of software is able to convert NTFS partition to FAT32 without using data. In most cases this is bullshit and it turns out to be only a huge time waste on installing software, that is only able to achieve such converstion, by formatting drive or that it can’t do that at all.

Formatting means loosing all your data, but those pesky morons just don’t gets this. So, here you have the only known to me method of getting your drive from NTFS to FAT32 under Windows, while keeping your data safe.

Note: Opposite converstion (FAT32 to NTFS) is much, much easier. Take a look at this article for tips on that.

Read More “Convert NTFS to FAT32 without loosing data”

Free hosting for ASP

You can find a lot of free hostings for PHP and MySQL, but not that much for ASP and MS Access. In addition to being free, these hostings also offer absolutely not ads, neither on your websites nor in sent e-mails:

100 MB might seem to be very low among nowadays offers (counted in GB or even not limited in space). But since you get: ASP Support, MS Access database and ISS 6 (on Windows 2003), absolutely free for lifetime with 100% no ads, then I think it would be hard to find similar offer with higher storage.

Changing keyboard shortcuts in PowerPoint… costs 40 USD!

When you go to Options for changing Ribbon settings, in your Word 2007 or Word 2010, you can see a small button at the bottom of button list letting you to change keyboard shortcuts for most areas of you text editor. When you go to exactly the same place in your PowerPoint 2007 or 2010 you my (surprisingly?) notice, that there is no such thing. Googling around the web let’s you discover that this is… normal situation!

Read More “Changing keyboard shortcuts in PowerPoint… costs 40 USD!”

Incorrect music or audiobook order in MP3 player

You may notice, that many MP3 players (both Windows programs — not tested on other OSs — as good as external hardwares) are making their file lists in some strange order. This may not be a big deal, when talking about music (though, when listening to a particular album, you may get yourself pissed-off as well), but became a really pain in the ass, if we’re talking about audiobooks.

Read More “Incorrect music or audiobook order in MP3 player”

Can’t pin folders to my Windows Explorer icon on the taskbar

When you right-click Windows Explorer icon on the taskbar in Windows 7, you can see list of recent items (i.e. recently opened folders) with an option to pin some of them permanently. On some Windows 7 systems user may experience issues with recent items and pinned entries list not being displayed, missing or cleared without reason. New items cannot be added to these lists.

Read More “Can’t pin folders to my Windows Explorer icon on the taskbar”