Changing default PowerPoint presentation

Changing default document for Word (i.e., the one, that is opened each time you start Word) is an easy task. You just have to open %APPDATA%\Microsoft\Templates folder and save any document as Word Template under Normal.dot file name in this location. Changing default PowerPoint isn’t that easy, because file names and file paths are different. I keep forgetting about this, so I wrote this article as my personal memo.

Read More “Changing default PowerPoint presentation”

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”

Password prompt when accessing account without password via network

If you are trying to access computer, that has only one account, without password, you’ll be asked to provide password anyway. This is normal. By default, Windows blocks all non-local logins to accounts that don’t have passwords, for security reasons. There are few things you can do with this situation.

Read More “Password prompt when accessing account without password via network”

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”

Access Send To menu in Windows [updated]

No, you don’t need to install any extra program, to edit contents of Send to... context menu in Windows (source).

Instead, open any Explorer window and paste this as folder path:

%APPDATA%\Microsoft\Windows\SendTo

or hit Win+R, enter or paste shell:sendto and hit Enter.

This was proven to work in Windows 7 and 8. Most likely this works in Windows XP, Vista and 2000 as well.

[update] This still works nine years after writing this article, in Windows 10 and 11.

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”

Write a directory tree to a text file in Windows command line

I found a question “How to write a list of directory trees to a text file?” on Stack Overflow, as I was looking for exactly the same solution. It has two brilliant answers, and since I’m using this blog as my personal remember-that-diary, I decided to share it here, so I shouldn’t look for this solution again.

Read More “Write a directory tree to a text file in Windows command line”

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 losing data [updated]

Many people on many forums and websites claims that this or that piece of software is able to convert NTFS partition to FAT32 without losing data. In most cases this turns out to be only a blunt lie and results in a huge time waste on installing software that is only able to achieve such conversion by formatting partition.

Here you have the only known to me method of getting your drive from NTFS to FAT32 under Windows, while keeping your data safe.

One small note. Before I was really able to perform NTFS-to-FAT32 conversion without losing data I wasted hours on installing and uninstalling crappy software which was expected to be able to do such conversion, but eventually turned out not. This irritated me a little bit, so expect (and please, forgive me for) a harsh language in this article.

Read More “Convert NTFS to FAT32 without losing data [updated]”

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.

Tables with multilevel lists inside in Microsoft Word

Tables with multilevel lists inside are rather uncommon element of Microsoft Word documents, but sometimes this is the best solution, you can have. For example, when you need tree-like structure (multilevel list) on the left with additional columns to the right. But, in general, it is harder piece of cake to build and manage them.

Read More “Tables with multilevel lists inside in Microsoft Word”

Changing keyboard shortcuts in PowerPoint… costs (40) 150 USD! [updated]

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!

2023 Update: It is still a normal situation for Microsoft. Only this time you have to pay 150 USD per year (!) to gain the ability of changing keyboard shortcuts (that is: the most basic feature of every software)!

Read More “Changing keyboard shortcuts in PowerPoint… costs (40) 150 USD! [updated]”

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”