Archive for the ‘Computing’ Category

Paste Unformatted Text, Revisited

Thursday, February 18th, 2010

A while back, I published an article in Dian Chapman’s TechTrax about how to create a keyboard shortcut for pasting the contents of the clipboard as plain text. That article, entitled Paste Special Unformatted Text at Your Fingertips, was mostly about Word 2003 and earlier. Here’s a quick update on how to do the same thing in Word 2007 and the upcoming Word 2010.

Word 2007 and Word 2010

There are several ways to accomplish the underlying goal. If you want unformatted text to be the default when you press Ctrl+V, click the Office button and choose Word Options ? Advanced. In the Cut, Copy, and Paste section, set the first four Paste options to Keep Text Only, as shown here. If you ever want a different action, then you’ll need to use Paste Special, which is assigned directly to Alt+Shift+V in Word 2007 and 2010.

Another method is to assign the following macro to the desired keystroke:

Sub PasteUnformatted

Selection.PasteSpecial Link:=False, DataType:=wdPasteText

End Sub

Yet another method requires three keystrokes, starting with Word 2007 and Word 2010′s, Paste Special keystroke: Ctrl+Alt+V. So, using this method requires that you press Ctrl+Alt+V, tap the “u” key, and press Enter.

Word 2010 Only

In Word 2010, there finally is a dedicated built-in command that can be assigned directly to the keyboard, without need for an intervening macro. If you’d like to have a “paste text” keystroke while leaving the default paste keystroke intact, then assign the PasteTextOnly command to the desired keystroke. Shown here, I’ve assigned it to Ctrl+Shift+V, no longer using the macro I’d been using for the previous ten years.

My favorite Outlook 2010 Feature

Wednesday, January 6th, 2010

Are you using the Office 2010 public beta? It’s pretty darn stable and I’ve been using it since November. One thing I like in particular about Outlook 2010 is that the Navigation Pane font can be changed directly at long last. No longer are you stuck with the default 8 point font, or having to experiment with system fonts to see which one affects the list, and then trying to find something that works here while not breaking something else.

At the bottom of the Navigation Pane, click the Configure buttons dropdown arrow, shown below, and then click Navigation Pane Options.


In the Navigation Pane Options dialog box, click Font. Finally, in the Font dialog box, choose a font and size that work better for your vision, assuming that Segoe UI 8 isn’t something you’d choose.

Returning to the last editing spot in Word 2007

Wednesday, September 2nd, 2009

Many Word 2007 users miss the ability to press Shift+F5 to return to the last place editing occurred in a document they open. Shift+F5 executes Word’s built-in GoBack command. It continues to work just fine in a document you’re editing, cycling among the current and last three places editing occurred. However, it does not work for a document you’ve just opened in Word 2007.

If you’re up for a little bit of very simple VBA programming, you can create the ability to automatically return to the spot where the cursor was the last time the document was saved. It works like this. When you close a document based on Normal.dotm, if you have a macro named AutoClose, that macro gets executed each time you close a document. When you open a document, if you have a macro named AutoOpen, that macro gets executed.

Note that you can set this up in other templates as well, but putting the system into the default global template—Normal.dotm—will handle most of the documents most people edit.

So, the first step is to create AutoClose (if you don’t already have an AutoClose macro), and include in it the instruction to insert a bookmark. I named this bookmark LastEdited. You could call it whatever you want. You could call it UncleFreddy or AuntPetunia. It doesn’t matter, as long as the act of setting it is contained in an AutoClose macro. The macro looks like this, at minimum:

Sub AutoClose()

    On Error Resume Next

    ActiveDocument.Bookmarks.Add Range:=Selection.Range, Name:=”LastEdited”

End Sub

 

So, each time you close a document based on the template that contains the AutoClose macro, a bookmark named LastEdited is created. I’ll bet you can see where this is going.

Each time you open a document, if the underlying template contains a macro named AutoOpen, it gets executed. So, guess what we’re going to have that AutoOpen macro do! Right! We’re going to have it take us to the LastEdited location. At a minimum, the AutoOpen macro will look like this:

Sub AutoOpen()

    On Error Resume Next

    Selection.GoTo What:=wdGoToBookmark, Name:=”LastEdited”

End Sub

 

That’s it! Creating the macros and setting the security is up to you. I said “at minimum,” because you might want your AutoOpen macro to do other things, like set the zoom at 140%, put the file location into the title bar, or fix you a cup of tea. These frills are entirely up to you.

You might be wondering what the On Error Resume Next is for. That’s there in case the macro encounters some kind of problem. The first time you open a document, for example, there will be no LastEdited bookmark. Without the error handling statement, you’d get a nastly little dialog box. Or, what happens if you’re editing a protected document and can’t create a bookmark. Same deal. The error handling statement keeps you from getting an error message.

One side effect of this system is that you will always be asked whether to save the file. That’s because inserting the bookmark is an edit. If you say No to saving changes, then the bookmark will not be saved.

So, what happens if there’s already a bookmark named LastEdited? Simple—it gets overwritten by the new one. If you think there’s some chance that there’s an unrelated bookmark named LastEdited in any of your documents, then give this one a different name… like TheInsertionPointLocationTheLastTimeThisDocumentWasSaved.

Is Firefox 3.5x slow to load some web pages?

Tuesday, August 11th, 2009

If Firefox 3.5x is running slowly for you, you might have the same problem I had.

I installed Window 7 Ultimate on Sunday, August 9th. As is usually the case when I install a new OS from scratch, rather than updating an existing installation, there was a flurry of installing needed software applications and utilities. One of the first things I installed was AVG Free for antivirus. Around that time, I also installed Firefox—my default browser.

Over the past day or two, I was noticing increasingly that getting into some websites was taking a long time. Worse, it would often take multiple tries, because Firefox would time out and tell me that the web site could not be found, and had the audacity to suggest that I check my internet connection. To me, this is like when your lamp won’t turn on, the help manual for it (you mean your lamps don’t have Help manuals?) suggests that you go to the eye doctor and make sure you can still see. Or, take your pulse, and make sure you’re still among the living.

In any case, I decided to try Internet Explorer to see if it was having the same issues. It wasn’t! Whoa. A clue!

So, I immediately started comparing settings to see what was different. The obvious, like some proxy having been snuck in by an evil website, turned out not to be the problem. Then it hit me—add-ins!

So, I selected Tools
–> Addons from the menu, and saw a promising suspect: AVG Safe Search. I remember saying Yes to this when I installed AVG, thinking “Oh, that might be helpful.” Little did I know that it would quickly become the source of much annoyance.

So, I disabled it and uninstalled it and restarted Firefox. Bingo! The slowness was history. What I’d spent the past 36 hours blaming a DDOS attack for wasn’t the problem at all. It was me, having shot myself in my own foot, by not carefully asking “Do I really want this feature?” I’m usually a bit more methodical when I add something new. But, when I install an operating system and just want to get up and running ASAP, I don’t follow my own best practices. In any case, hopefully, my having realized the cause of my slowness issue can perhaps help someone else. Hence, the blog.

Example for CW Lee

Tuesday, June 2nd, 2009

The Open dialog box in Word 2007:

Trillian Hijacks Ctrl+Shift+A and two other shortcuts

Wednesday, May 6th, 2009

All of a sudden, Ctrl+Shift+A stopped working in Outlook and Windows Mail. In Outlook, I used it to create a new appointment, and I use it in Windows Mail to mark all messages in the displayed newsgroup as Read.

Long story short: It was Trillian, which I recently started using, albeit sporadically. Until yesterday, apparently, I had not tried using Ctrl+Shift+A while Trillian was running.

Trillian was reserving, but not using, three keyboard shortcuts: Ctrl+Shift+I, Ctrl+Shift+A and Ctrl+Alt+C. Reclaiming them for your own purposes is a two step process. First, the delete them from Trillian’s Advanced Preferences. Then, you close and restart Trillian.

Right-click Trillian in the system tray, and choose Trillian Preferences. Click on Advanced Preferences. In the left pane, click on Automation. Under Automation, scroll down until you see the first reserved keyboard shortcut. Click on it, and Change… and X (delete) options appear. Click the red X, and poof! Remove any other offenders in the same way, then close the Preferences box, and close and restart Trillian. Those keyboard shortcuts will no longer be hijacked.

Caveat Canon Cartridge Claim

Monday, April 20th, 2009

Can you tell that I have a thing for alliteration?

I have a Canon Pixma iP5000 with which I’ve been mostly satisfied. It cleans the jets before and after each printing, and I haven’t had any of the issues I had with my HP1200, where things got clogged and the printer became unusable after a couple of years. Everything I print with the Pixma has been crisp and clean, as long as the ink cartridges haven’t run dry… which brings me to my one gripe.

In what I can only conclude is an effort to improve Canon’s bottom line, the printer’s sensors sense way prematurely that you’re out of ink. I don’t do a whole lot of printing—maybe a few pages a week. So, my ink cartridges should last me a long time. Until about six months ago, each time it told me that a cartridge was empty, I naively believed it, and replaced it. At the time, Costco—where I bought the printer—was still stocking the replacement cartridges, so it was no big deal. Canon, Costco, and I were pretty satisfied.

About six months ago, I got a message that my cartridges were running low. So, I put them on the list for my next trip to Costco. To my horror, however, Costco now stocked only some of the cartridges I needed, and not the ones that allegedly were running low. I mentally back-burnered the problem, thinking I’d either order online or cave and pick up one from Office Depot when it finally did run dry. This was over six months ago.

Sure enough, about two weeks later, I got a message that the smaller black ink cartridge (6e) was empty. Because I needed what I was trying to print (the IRS doesn’t understand “sorry—I was out of ink”), I decided to push the reset button and see if whatever it printed (despite the message) would at least be dark enough. It was perfect. No problem at all. And… the message I see when I print went back to “running low” instead of empty.

So, I decided to see how long I could engage in this little charade. I’ve now pushed the “you’re lying to me, go ahead and print” button at least three times. Each time, my persistence and skepticism has been rewarded with a perfect copy of whatever I wanted to print, and a restoration of the “running low” status. In fact, the “running low” status stays at par for many more printing episodes, only reverting to the “empty” lie after many successful printings. So far, I’ve never actually witnessed a cartridge going empty, so there’s no telling how much more mileage I can get out of the current cartridges.

I’ve concluded that prior to this discovery, I must have wasted many cartridges that were not really anywhere close to empty, but which I thought were empty. I’ve probably saved $100 or more, not to mention the reduced impact on the environment.

Bottom line… if you have an iP5000, don’t necessarily believe that it’s telling the truth when it says you’re out of ink. Push the reset button (just below the power button) and see if what you get is acceptable. My guess is that it will be, and that you’ll get a good deal more printing out of that “empty” cartridge..

A solution to “Word cannot register your account” for Word blogging

Sunday, April 5th, 2009

When trying to register my wife’s WordPress blog with Word so she could blog directly from Word, we kept getting the message Word cannot register your account. I got this message periodically when I registered my own blogs, but it eventually worked. So, kept it up. No joy.

After failing for several days, I finally decided to see if something more was known about the problem to try to see if it was a “you gotta live with it issue. Eventually, I found the answer! As it turns out, it’s a setting in WordPress’ Dashboard. I don’t recall seeing this setting a few years ago when I registered my blogs, so it might be something new they added to make things less hit-or-miss. In any case, it worked! Here’s the fix.

  1. At the bottom of the left column, under Dashboard, click on Settings. This will expand the list of settings sections.
  2. Click Writing.
  3. Under Remote Publishing, enable XML-RPC. If you think you’ll ever use Atom, then enable it, too, just for the heck of it.

At the bottom of the Dashboard window, click Save Changes. And Bob’s your uncle!

Six cute new IE8 features

Saturday, March 28th, 2009

I’ve been exploring the new Internet Explorer 8. While I’m not giving up Firefox anytime soon, IE8 does have some potentially useful new features. Here are six that you might find useful, or at the very least cute.

1. Color coded tabs. When you click a link or initiate a search from a tab, the tabs are color coded so that you can see which tabs are associated.

2. IE8 now has “caret browsing”. You toggle it on/off using F7. This feature puts a visible text cursor into the web page so that you can see where you are in the page.

3. When you select text, a button appears containing “accelerators” that can do something with the selected text. My favorite is Search with Google, since this saves me several steps.

4. IE8 can now open the last browser session—whenever you want, not just after a crash.

5. If you accidentally close a tab, IE8 can reopen it. Just right-click any existing tab.

6. You can give IE8 amnesia about your surfing. Look back at the picture for #4—second option from the top. If you press Ctrl+Shift+P (or choose InPrivate Browsing from the menu), IE8 turns off the tape recorder and starts a new copy of IE8. It will cache and remember for the InPrivate session. But, when you close the InPrivate session, IE8 will suddenly be saying “Numbered Swiss Account? What numbered Swiss account?” Any trace that you ever did what we know you didn’t do will be gone.

Where can you get the new IE8? Hmmm Here… let me Google that for you:

http://www.lmgtfy.com/?q=download+internet+explorer+8

lmgtfy is the ultimate in helpful arrogance. I’m still waiting for an occasion to use it, but I’m afraid of hurting anyone’s feelings.

Windows Sidebar Clock Can Steal CPU Cycles!

Saturday, March 21st, 2009

Last night, I noticed that programs were taking a while to start, and my computer was being sluggish in general. I right-clicked Windows Vista’s Taskbar and started the Task Manager to see if I could figure out why. In the Processes tab, I clicked CPU to reverse sort by CPU consumption.

In this picture, both instances of sidebar.exe were showing 0%. Last night, however, one of the sidebar.exe instances was showing 50% CPU usage! Note that there might be two instances of sidebar.exe running. I’m given to understand that the second process is used for managing Sidebar gadgets that do not come with Vista.

In any case, the question for me was WHY?

I closed Sidebar, and CPU usage for it dropped to 0% (although the two processes did not close). I restarted Sidebar, and the 50% problem returned after a short while, although not immediately.

Long story short… I traced the problem to the analog clock that comes with Vista’s Sidebar. I tried closing the gadgets one at a time, thinking that the problem would be with WeatherBug or one of the other add-on Gadgets. But, the problem went <POOF> (that’s techspeak for disappeared) when I right-clicked the clock and chose Close Gadget.

I checked on my laptop computer and the problem does not exist there, so I don’t know how widespread the issue is. However, if you’re noticing that the computer seems to be churning when you aren’t aware of any big programs running… do what I did—check the Processes list in the Task Manager. And, prepare for the unexpected!

In any case, my computer is running a good deal faster this morning. I temporarily replaced the clock that comes with Vista with something called Digital Dutch Clock. But, it exhibited the same problem as Vista’s built-in one. When I get around to installing Windows 7, I’ll have to see if it has the same clock issue. But, for now, I’ve placed an old wooden clock where I can see it.