How to move your temporary files to a ramdisk

Moving the rest of your temporary files to a ramdisk provides a number of performance benefits. Program installations proceed noticeably faster, and fewer files written to your system disk means less fragmentation, less maintenance for an SSD, and, most likely, longer SSD life.

Read more

A Firefox ramdisk profile in Windows

I’ve been using Dataram’s excellent free ramdisk program for several months now and highly recommend it. On some machines, I install Firefox to the ramdisk and move the profile there. But the biggest benefit comes from putting the profile (not just the browser cache) in the ramdisk. Storing the profile in a high-speed, near-zero-latency ramdisk solves virtually every Firefox performance issue. Here’s how to set up a Firefox ramdisk profile in Windows. Read more

How to make persistent headers in Excel

My boss and I are compiling a huge Excel spreadsheet that summarizes everything our organization has ever done. It’s as big of a pain as it sounds. What makes it worse is having to scroll all the way back to the beginning to view the headers. The solution: make persistent headers in Excel.

The trick to making a persistent header that shows all the time, even after scrolling, hides in the View tab in Excel 2007.
Read more

Customize Firefox before it hits the ground on a new PC

Here’s a nifty-looking program: Firefox Addon Maker, which allows you to create customized Firefox installer packages.

This is helpful if you install Firefox a lot, whether in corporate or home settings.
Read more

Libre Office grows up some more

Libre Office 3.5 is out. I need to look at it. My big beef with Open Office all along was that it made current hardware, whatever it was, feel like Office 97 running on a 486. Or perhaps a Pentium-75.

They’re saying all the right things now. Lots of new eyes looking at the code, reviewing the code, dropping obsolete code, streamlining it and making general improvements. Netscape 4.5 was a bloated mess too, but once the Mozilla team got some fresh eyes looking at it, the situation improved. Eventually they had to break the browser out into what became Firefox, but they had the freedom to do that.

And in the meantime, I suppose if it’s too slow, you could throw hardware at the problem. 8 GB of RAM costs $40 or less right now. Carve out a ramdisk of 1-2 GB and install Libre Office in that, and it’ll load pretty fast. It’ll eliminate any I/O-bound bottlenecks.

Quick and dirty OCR, included with Office 2003 and 2007

At work we have a document scanner that outputs files to PDF and e-mails it to us, but the PDFs are really just full-page images mashed together as a PDF because the scanner doesn’t have OCR capability.

Here’s how to extract the text using Microsoft Office 2003 or 2007. It’s imperfect, but here’s what you can do with the tools you already have.
Read more

Vacuum Firefox automatically

I’ve discussed vacuuming Firefox before to make it run like new, but it’s not something everyone is exactly comfortable doing. I found an extension called Vacuum Places Improved that allows you to vacuum Firefox automatically.

Most importantly, in the options for the add-on, you can make it run, say, every 50th time Firefox starts. That way, the vacuum process happens transparently–at the expense of every 50th load being slower, the database gains automatic maintenance. I’ll gladly trade occasional slower load times for improved performance.
Read more

An ode to Word macros

Last week, John C Dvorak wrote about technical duds. And it’s unfortunate about what happened to Word macros, because at times they can be extremely useful, and not terribly difficult to use, either.

Here’s my favorite macro–a method to join single lines. You’ll wonder why it never became a standard feature in Word. You won’t use it often, but when you need it, you need it badly.

Read more

Get Acronis for free

There isn’t much time left, and I apologize, but for the rest of the day, you can get the home version of Acronis for free. Details at the link. It’s not a bad idea to be familiar with Acronis, since it’s so widely used by businesses. Getting it and using it on your home PCs will get you some relevant experience. I’m not sure what the differences are between the home and business versions (I haven’t seen the home version yet myself), but using it will put you in position to figure it out. And you can’t beat the price, right?

I may have a cure for the slow web browser

John C Dvorak lamented last week about slow web browsers.

I’m working on a cure.

Read more