Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Thursday, December 31, 2009 – Permalink –

Forms in Word

With and without code


Data entry forms can be designed and presented using VBA code. Another simpler way to do it is to construct a form directly in the Word document.
"Have you ever been asked to fill out a form in a word processor, only to discover that when you attempted to enter information, the lines on the form moved all over the page? Not to mention that the form was difficult and time-consuming to fill out? Most people don't realize that you can easily create professional-looking forms in Word."


  • Part I: Create professional looking forms in Word

  • Part II: Adding Automation to your Word forms

  • Part III: Learn more about VBA macros to automate your form

  • Part IV: Use custom dialog boxes in your Word forms

  • Part V: Linking your AutoForm to a database
Please Fill Out This Form!

By Dian Chapman at TechTrax

Also:

 Fun with Forms

Cindy Meister



See all Topics

Labels: , , ,


<Doug Klippert@ 3:13 AM

Comments: Post a Comment


  Saturday, December 19, 2009 – Permalink –

Notes from Word

Import it all



One technique that can be used when preparing a PowerPoint show, is to import material from an existing Word Outline.

If the Word document is formatted with Heading styles, Heading 1 will become a new slide and the subsequent headings, 1 through 6 will become bullet points on the slide.

It may be desirable to prepare notes for each slide while developing the Word outline. Notes don't appear on the slide, they are placed on a separate page that can be printed out for the speaker or handed out to the audience.

Bill Dilworth has written a macro that moves information that has been formatted, say at Heading 6, and places it on the notes page:

"This macro outline allows the user to use Word's "Send To PowerPoint" feature, then run this macro to get notes from MS Word to PowerPoint as notes. The macro allows you to set the text level you want to become the notes.


Word Outline to Notes Page in PowerPoint




See all Topics

Labels: ,


<Doug Klippert@ 3:25 AM

Comments: Post a Comment


  Tuesday, December 15, 2009 – Permalink –

Change Insert Picture Target

File location


If you would like to specify the folder Word will default to when you go to Inset>Picture:
  1. From the Tools menu, click Options.

  2. Select the File Locations tab.

  3. Select ClipArt Pictures from the File Types list.

  4. Click the Modify button.

  5. Navigate to the folder you want Word to default to.

  6. Click OK. OK.



In 2007-10, you'll find the entry by
  1. Click on the Office logo

  2. Go to Word Options>Advanced

  3. Scroll down to General

  4. Click the File Locations button



See all Topics

Labels: , , ,


<Doug Klippert@ 7:24 AM

Comments: Post a Comment


  Thursday, December 10, 2009 – Permalink –

Templates are Digital Stencils

Make your own


If you have a document; such as a report or reoccurring newsletter, one way to reduce the production time is to create a template.

These preformatted, boiler plated documents can then be fleshed out without having to reinvent the sardine.

Here are some tutorials to help you along:

AddBalance.com
Template Basics

About.com
Word Templates




See all Topics

Labels:


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Wednesday, December 09, 2009 – Permalink –

Sparklines

Quick graphic reinforcement


A graph or chart can give the reader a visual representation of a great deal of data. Concepts or results can be more easily grasped by a well formatted graphic.

Charts, usually, take up more space in a document than is absolutely required.

Edward Tufte has come up with the concept of Sparklines (Sparklines:Intense, Word-sized Graphics)
.
These are small graphs about the same height and width as common words. They are not out of place in the text of a document.

Sparklines give the reader a snapshot of the data that quickly supports the material being discussed.



See:
Bisantz Sparklines

The Sparkmaker can create Sparklines for Word, Excel, or PowerPoint. They can also be produced in HTML.




See all Topics

Labels: , , ,


<Doug Klippert@ 3:27 AM

Comments: Post a Comment


  Monday, December 07, 2009 – Permalink –

Hidden Macro Names and Shortcuts

Revealed


Word has built in macros to perform routine actions such as using the Format Painter to copy formatting.

Rather than trying to guess the name or look up the shortcut keys, use this seldom mentioned trick to find toolbar macro names.

Press the three key combination of Ctrl, Alt, and + (the plus sign on the Numbers keypad).

The mouse pointer changes to a 4-leaf clover.

Click on a toolbar icon. Word will display a form revealing the macro name and the assigned shortcuts.



(It works the same way in 2007-10)




See all Topics

Labels: ,


<Doug Klippert@ 7:22 AM

Comments: Post a Comment


  Friday, December 04, 2009 – Permalink –

Password Background

Unencrypted

Alan Myrvold has written a background article on how Office handles passwords and what password strength means.

"Word, Excel, and PowerPoint have been able to password protect documents for several versions by setting the 'password to open'. What we felt could be improved was the ability to enforce password strength rules, similar to what may be required when logging into your computer at work."






See all Topics

Labels: ,


<Doug Klippert@ 3:56 AM

Comments: Post a Comment


  Tuesday, December 01, 2009 – Permalink –

REDUSE MISSPELLINGS

You might be missing typos in tables

If you've ever found typos in a table or list that you're positive you remember spell checking, chances are that the typos are in words that are purposely skipped during the spell check.

By default, SpellChecker ignores words that are all upper-case or that have numbers in them. In most cases, this is probably fine. However, especially with purchased data, you'll occasionally come across tables where everything is capitalized.

Fortunately, you can change the way SpellChecker works so that all words are included.

To do so, run the SpellChecker on a data selection that will cause the Spelling dialog box to be displayed.

Then, click the Options button and clear the Words In UPPERCASE and Words With Numbers check boxes.

Finally, click OK and then Cancel.




See all Topics

Labels:


<Doug Klippert@ 3:46 AM

Comments: Post a Comment