Computer geek, and self-appointed know-it-all, Westley Annis answers all those hard 

questions about anything related to computers and technology, as well as business and 

political questions.

Have a Word Macro Detect Your Thumb Drive

I keep all my word files on a 8 gb USB jumb drive so that I can take them from one computer to another. I have all my templates and custom macros in one directory. I have a macro to attach the template to the documents.

The problem is the drive letter changes as I move the USB drive from computer to computer. Then I get an error and I have to use debug to change the drive letter at the start of each session. Is there any way to make the macro look for the template taking into consideration that the drive letter may change.

Thank you,

Question asked on February 4, 2009 at :55 AM :: Comments to date: 0

Displaying the Following Year in a Word Document


I have a word document that is a membership renewal form that is sent out once a year...

I want to place a date (Year only) field on the form that displays the year that the form refers to ... eg the form is sent out towards end of 2008 for the 2009 calender year so I want to display 2009 then 2010 at end of 2009....etc

As I am currently doing this I want to automate the form so as anyone who sends them out in future does not have to remember to update for each year (as has been missed in past)

I have had a look at date field options but can not find a way of doing it.

Any help gratefully accepted.....


Question asked on December 29, 2008 at :11 PM :: Comments to date: 0

Microsoft Out-of-Band Security Update

I just received an email from Microsoft about an Out-of-Band security update. What is an out-of-band update?


Question asked on December 16, 2008 at :33 PM :: Comments to date: 0

Adding the file path to a Word 2007 Document

I'm pretty new to Word 2007 and am trying to put a document path on the bottom of each document (footer perhaps). This is so I can find where the document is filed. I have been exploring the Text, Quick "Picks," Category and Fields, but, so far, cannot figure it out. Help!

Thank you in advance!

Question asked on December 14, 2008 at :06 PM :: Comments to date: 0

Outlook 2007 Search Bar Shortcuts

Microsoft Outlook 2007 has a Search Bar that allows you to quickly search all fields of a message. Is there a way to limit the search to a particular field?

Question asked on July 4, 2006 at :15 AM :: Comments to date: 0

Free Version of Microsoft Office?

We have Windows XPhome on our computer and find that we need Xcell for some reports we have been asked to do. I have heard that there is a free download of Xcell from microsoft if you own a licensed version of windows. Is that true? And how would you go about getting it? I am also interested in learning Power Point and have been told that is also available for free download. I just need to know if what I have been told is correct or if I will need to purchase those programs separately for my computer. Thanks

Question asked on March 17, 2006 at :29 PM :: Comments to date: 0

Change Excel Find Formula Defaults

Dear Westley, In an xcell worksheet, using the "find" icon initially, the settings are for "rows" and "formulas". I rarely search by rows and almost never by formulas. It would be far handier if the "initial" choices were already set to "columns" and "values" -- which is how I search 98% of the time. Q -- Is there a way to change the script so that the initial choices would be set to the way I most often search?

Question asked on August 21, 2005 at :01 PM :: Comments to date: 0

What page am I on?

I've got a macro that searches through Word documents looking for broken bookmarks and TOC entries and generates a report so they can be fixed. The problem is I can find the broken elements, but I don't know what page they're on so I can manually find them and fix them. How do I find out what page number I'm on inside of a macro?

Question asked on August 16, 2005 at :08 PM :: Comments to date: 0

What macro is a menu item pointing to?

I've got a bunch of custon menu entries on my menu bar but I don't know which macro they point to. How can I find out?

Question asked on August 8, 2005 at :22 PM :: Comments to date: 0

Create a hyperlink in Word from a drop down list

How can I create a hyperlink in Word based off of a Dropdown field?

Question asked on July 30, 2005 at :40 AM :: Comments to date: 0

How can I add an EXE file to a Word toolbar?

How can I create a button in Word to launch a custom application?

Question asked on July 24, 2005 at :30 PM :: Comments to date: 0

Ask Westley your question on technology, business, or politics!
Add to My Yahoo!
Subscribe in 
NewsGator Online

All Categories
Archives by Category
Book Links
Powered by
Movable Type 4.1
© 2005 by Westley Annis. All Rights Reserved.

Valid XHTML 1.0!