Windows Tools, Help & Guides

This is part two of a new series I’m writing, teaching you how to get more functionality out of your Excel. If you are not familiar with Macros I suggest you read the first part, before beginning on this one.

In Part Two…

In this part we are starting off  using some of the commands you should know, and then create a Macro that decide filename, which folder to use, before exporting the document to PDF-format. I am also going to show you how to create a button to trigger the macro.

As in the first part, I am using Office 2010. Even though the code and programming are the same in older versions of Excel, the images and buttons may differ from what you see on your screen.

Enough Chit Chat, let’s get this party started…

Read the rest of this entry »

IF you are to really learn just one Office application, then you should choose Excel. Because it is the most versatile and powerful of all the Office applications.  With Excel you can almost get rid of the other Office applications all together. A side from the normal calculations you can write letters, create databases with powerful reports and analyze tools, create useful forms for everyday chores, and program powerful small applets. Within certain limits of course.

Using Advanced Macros

Most users have come across the word MACRO, one time or another using Excel. A macro is a recording of sorts, that stores your actions, step by step. Macros are used to eliminate the need to repeat the steps of common tasks over and over. Tasks such as adding or removing rows and columns, selecting a range of cells, or changing textcolor, fonts etc. In Excel, macros are written in Visual Basic for Applications (VBA). For those who cannot write VBA code, Excel allows you to record a series of steps – using keyboard and mouse – that Excel then converts into a macro.
In a few upcoming articles I am going to show you how you can create powerful and effective macros that hopefully will take your Excel experience to another level. How about letting Excel Copying Sheets, renaming them, Choose filenames, choosing between file locations and save the document as PDF sound ?

Sounds interesting ?

Read the rest of this entry »

So here’s the scenario.  You already have a working Windows 7 x64 installation on your system and you need to install x86 for testing purposes.

You left your Windows 7 x86 DVD at a friends house and your PC doesn’t support booting from USB.  You’re out of luck right?

UPDATE: You can download the RTM versions of Windows 7 Ultimate, Professional, and Home Premium here (64/32-bit available.)

Read the rest of this entry »

Windows Forums member, grr, asked the following question in our suggestion box:

There are 10 or more different types of keys for Microsoft products. example, VLM, KLM, abc, xyz, oem, etc. I have to admit that still till date I’m not having a proper and reasonable understanding of all these different keys. It would be great if a post could be made on the blog explaining the difference for these keys.

Read the rest of this entry »

Are you a fan of fonts? I know I am. And if you have visited this site for some time, you will no doubt be sitting on a huge pile of free fonts. Now, Windows doesn’t have a specific number of maximum allowed fonts you can enable (or install) – but installing each and every one you own at once, will increase boot time and may slow your system down to snail pace…There are many applications out there that will help you to manage your fonts by enabling the font you need – when you need it. The best programs also help you sort your fonts for easier management. The best ones, aren’t free (usually), and those who are, doesn’t always give you what you want, or need.For many years now I’ve been using a Font Management Program originally developed for the MAC platform called SuitCase. All though they have a free version, their best (and most functional, and costly) version is the paid version. Needing to upgrade my SuitCase Program I started out searching for a free tool that could replace it. Hoping to find at least one – I ended up with three promising alternatives. Read the rest of this entry »

TWC in conjunction with Lee Whittington have released IconCache Rebuilder for those of you experiencing weird problems with your icons in Windows 7.

[UDATE – See Rich’s How-To guide to fix your corrupt icon cache manually]

Sometimes you may find an icon that just won’t display correctly no matter what you do.

Read the rest of this entry »