All files in a folder

• The folder name for the listed files
  
• The file names of the files found
  
• The file sizes of the files found
  
• The dates and times of the files found
  
• The total number of files listed

Macro to List All Files in a Folder

Here are some other suggestions:

List Word and Excel Files



See all Topics
word

Labels: Macros

and other graphics

" Finding quality images and photos for complementing an important article, essay or news report is already quite a challenge for many. Imagine when the goal is not just too find good images, but find some that you could openly and freely use without needing to pay royalties or one-time publishing rights to someone."

Free Photographs and Other Visuals

A dozen sources are listed including:
PD Photo.org

"PDPhoto.org is a repository for free public domain photos. Unless something is clearly marked as being copyrighted, you can assume it is free to use. But if you intend to use an image you find here for commercial use, please be aware that standards for such use are higher. Specifically, you should assume no model release was obtained. And pictures featuring products or property should be used with care. The photos are here to be used, but I don't want you to get either of us in trouble over it."

Labels: Graphics

How it's done

"It's time to get up to speed with Microsoft Office Word 2007. Learn the best ways to use the new Ribbon, get a handle on finding popular commands, and understand what the new file format does for you."

Labels: Tutorials

Shape or substance

"The legibility of a typeface should not be evaluated on its ability to generate a good word shape.

Word shape is no longer a viable model of word recognition. The bulk of scientific evidence says that we recognize a word's component letters, then use that visual information to recognize a word. In addition to perceptual information, we also use contextual information to help recognize words during ordinary reading, but that has no bearing on the word shape versus parallel letter recognition debate. "

The science of word recognition
by Kevin Larson
From EyeMagazine

Suggested by:
Microsoft Typography

Also see:
Cmabrigde



See all Topics
word

Labels: Fonts, Formatting, General

Object with style

"At first glance, you might think that not much has changed in the latest version of Microsoft Word; however, when you take a closer you look and discover the added collaboration functionality, research capabilities such as Encarta, translation and more, increased security, and new XML-enabled opportunities, you will quickly realize that Word 2003 offers even more benefits for the legal user."

Word 2003 Legal User's Guide

The Payne Consulting document for Word 2002 is here:
Word 2002 Legal User's Guide

Charles Kenyon has put together the Intermediate User's Guide .
This Intermediate Users' Guide is based closely on the Legal Users' Guide and supplements it. It contains all the text from the original Legal Users' Guide together with additional guides and links to other resources.

Also see:
Microsoft Office Assistance:
31 Legal articles



See all Topics
word

Labels: Reference, Tips, Tutorials

Index resource

"Have you ever tried to include a passage in a different alphabet in one of your documents, for example a quotation in Russian in an English document, only to find that you have no Cyrillic characters available? Or sent a Spanish document in electronic form to someone in Greece, only to be told that the accented Latin characters have been replaced by Greek characters? Or produced a Web page that includes technical symbols and found that it works with Windows but not with Mac OS or Unix?"

Alan Wood's Unicode Resources
Unicode fonts for Windows computers

From the Word Help file:

If you know the Unicode (hexadecimal) value of a character, you can use the ALT+X keyboard shortcut to enter the character directly in your document.

Type the Unicode (hexadecimal) value of the character. Press ALT+X.
Note: The value string can also begin with U+.

Microsoft Word replaces the string to the left of the insertion point with the character you specified.

You can also use ALT+X to display the Unicode character code for a particular character. Place the insertion point to the right of the character, and then press ALT+X. The character is replaced by its character code. Press ALT+X again to switch back to the character.

• Љ — Hex=0409
  
• א — Hex=05D0
  
• ئ — Hex=0626
  

Labels: Fonts

"Attachers"

Microsoft Office Online tutorial:
Org charts A to Z

"Use the Microsoft Office diagramming tool to create an organization chart in Microsoft Office PowerPoint 2003. Build and lay out a chart, style it effectively, and get editing tips that'll help you adapt it."

(Length: 40–50 minutes)

Also:
Draw flowcharts with Word and PowerPoint
Connector information

PPTWorkbench.com:
(Glen Millar Communications)
Connectors and custom anchor points

"Connectors are very important tools in PowerPoint drawing. They attach themselves to PowerPoint shapes, and will move with that shape as it is moved around the slide. This tutorial will show many things:
How to add custom anchor points by:

1. drawing them,
   
2. pasting them as an enhanced metafile,
   
3. using a hidden autoshape."

Labels: Graphics, Tutorials

Budget0056.doc

"Sometimes, when working on a project, you may want to save your documents in sequential order (for example, "0001", "0002", "0003", and so on).

If you wanted to do this manually, you would need to sort through your working directory for the latest file number before you could assign the next number to a new file.

Using this fairly straightforward Word macro, you can make creating sequenced files as easy as pressing a button."

LogicalExpressions.com:

Save sequential number docs
(Kevin Christy)

Also see:

Autonumber Invoices



See all Topics
word

Labels: Customize, Fields, Formatting, Tips, VBA

Use local Help

1. Bring up the Help Task Pane (The F1 key will do this.)
   
   
2. At the bottom of the "See also" box there is a hyperlink: "Office Online Settings"
   
   
3. Click this link; you will get the Service Options dialog box
   
   
4. Uncheck the option: "Search online content when connected"

Office will now use the help files on the local hard drive. It is much faster!
(Editing will affect all Office applications)

In office 2007, left click on the "Connected to Office Online" and choose local



If you need to disable its use through a Group Policy, or in the Registry, see:

Microsoft Support:
How to disable Microsoft Office Online featured links in Office

Be aware that if you do turn it off, you might miss some of the Office online feature, like tutorials and downloads.

Office Online: Get More Out of the Microsoft Office System



See all Topics
word

Labels: General

The other letters

• Ctrl+'
  Adds an acute accent to the character typed next

  Á

  
  
• Ctrl+'
  When followed by d or D, creates the old English character "eth"

  Ð

  
  
• Ctrl+`
  Adds a grave accent to the character typed next

  À

  
  
• Ctrl+^
  Adds a circumflex to the character typed next

  Â

  
  
• Ctrl+~
  Adds a tilde to the character typed next

  Ã

  
  
• Ctrl+:
  Adds a dieresis or umlaut to the character typed next

  Ä

  
  
• Ctrl+@
  Adds a degree symbol above the letters a and A; used primarily in Danish, Norwegian, and Swedish

  Å

  
  
• Ctrl+&
  Creates combination or Germanic characters based on the character typed next

  Æ

  or

  ß

  
  
• Ctrl+,
  Adds a cedilla to the character typed next

  Ç

  
  
• Ctrl+/
  Adds a slash through the letters o and O; used primarily in Danish and Norwegian

  Ø

  
  
• Alt+Ctrl+?
  Creates an inverted question mark

  ¿

  
  
• Alt+Ctrl+!
  Creates an inverted exclamation mark
  

  ¡

  
  

Labels: Fonts, Formatting

Real world fonts

"I honestly believe typeface selection is one of the most transparent ways of detecting good - and bad - design. You can tell plenty about a designer merely by the typefaces he/she chooses. So you'd be wise to start with trusted faces, and you'd be even wiser to know something about the history of each typeface."

Labels: Fonts

Powerful tool

Masterviews International:

Edit Images And Photos Within PowerPoint: Picture Toolbar

"In PowerPoint you can control images using the Picture toolbar which automatically appears whenever you insert a picture in a slide. In case you do not see this toolbar, you can right-click on the image you have just inserted and choose 'Show Picture Toolbar'."

• Change the image to grayscale, black-and-white or watermark, thanks to the Color Control feature.
  
  
• Change the picture's contrast, with the More Contrast and Less Contrast controls.
  
  
• Change the picture's brightness with the More Brightness and Less Brightness controls.
  
  
• Cut off part of the picture with the Crop control.
  
  
• Recolor vector images (not applicable to bitmap images such as JPEG) with the Recolor Picture function.
  
  
• Format the picture with the Format Picture control.
  
  
• Select a color in the image and make it transparent, with the Set Transparent Color function.
  (For 2007 this is under "Recolor" > Adjust . Set Transparent color)
  
  
• Undo all operations that you have applied to the selected images with the Reset Picture control.

Labels: Graphics

Recover zapped files

The AutoRecover feature does not replace the saving of a document. There is no feature in Word to automatically save your document files. You must periodically save your documents.

What Is the AutoRecover Feature in Word?

How Word creates and recovers the AutoRecover files

"When you perform a full save of your file, there is no way to go back to your original version. If the document was saved automatically, in many instances data would be lost because a full save is irreversible.

In contrast, AutoRecover does not overwrite your original file; this allows you to back out of most errors just by not saving changes when you close the file.

An AutoRecover file is created or updated each time there are changes that have not been saved at the end of the preset time period. You should perform a full save specifically based on progress you've made in your document rather than arbitrarily at regular time intervals.

NOTE: Another way to protect your work and maintain all of your changes is to use the Versions command on the File menu."

Also:

Word.MVPS.org:
How can I make Word save or back up my document automatically?

By design, Microsoft Word does not create an AutoRecover file when you are working in a master document, because the AutoRecover file format is not compatible with the master document file format.

When you use Word as your e-mail editor, Word does not create an AutoRecover (AutoSave) file of your e-mail message.



See all Topics
word

Labels: Documents, Tips

Avoid the squiggles

1. Select the text you would like the spell checker to skip.
   
   
2. Next, select Tools>Language Set Language from the menu bar.
   
   
3. In the Mark Selected Text As list box, select the (No Proofing) option and then click OK.

From now on, the spell checker will skip over the text you selected without flagging any spelling or grammatical errors.

Alan Wyatt's WordTips site has a comprehensive list of spell checker links:
Spelling and Grammar Checking

BTW:
If you want to spell check Web forms and information boxes you fill out using Internet Explore, look at ieSpell:

"ieSpell is a free Internet Explorer browser extension that spell checks text input boxes on a webpage. It should come in particularly handy for users who do a lot of web-based text entry (e.g. web mails, forums, blogs, diaries).

Even if your web application already includes spell checking functionality, you might still want to install this utility because it is definitely much faster than a server-side solution. Plus you get to store and use your personal word list across all your applications, instead of maintaining separate ones on each application."

ieSpell.com



See all Topics
word

Labels: Documents, Reference, Tips

Security levels

High:

A computer user can open without a prompt a digitally signed project from a trusted publisher. Otherwise, the application blocks opening signed projects from untrusted publishers as well as unsigned projects.

Medium:

A computer user can open without a prompt a digitally signed project from a trusted publisher. In addition, you can also designate the publisher of a signed project as trusted so their projects will open without a prompt in the future. Unsigned projects are always prompted with a reminder that the file may contain potentially harmful code, but users can elect to open them anyway.

Low:

A computer user can open an unsigned project without a prompt. When users make a Low security setting, they're reminded that they aren't protected from potentially unsafe macros.

"If you've used Access 2003, you've probably seen several security warning messages - Access 2003 cares about your security. An important part of Access 2003 security is digitally signing your code. As Rick Dobson shows, you can do it, but preparing for digital signing is critical.

A digital signature acts like shrink-wrap on your project: Clients know that they're getting a copy directly from you that no one else modified. Clients will also know that they're working with "your" code and not any version of it modified by a third party. As computing moves forward into a "security conscious" era, learning how to acquire and use a digital certificate is also important for interfacing with organizations that adopt policies of only running digitally signed Access 2003 projects: Your users may refuse to accept software from you that isn't shrink-wrapped."

Also:
Signing Access 2003 Projects

Other links:

How to make sure that your Office document has a valid digital signature in 2007 Office products and in Office 2003

Also:
HAL-PC MS Office & Excel SIG in Houston, Texas:
Digital Certificates and Trusted Sources for running Excel Macros under High Macro Security



See all Topics
word

Labels: Macros, VBA

Creating sequentially numbered documents

In the template from which you create the document, insert a bookmark named Order in the location where you want the sequential number to appear and create an AutoNew macro, as follows:

Sub AutoNew()
Order = System.PrivateProfileString("C:\Settings.Txt", "MacroSettings", "Order")
If Order = "" Then
  Order = 1
Else
  Order = Order + 1
End If
System.PrivateProfileString("C:\Settings.txt", "MacroSettings", "Order") = Order
ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")
End Sub 

If you do not need to display the number in the document, but just want to save it with a sequential number, there is no need to create the bookmark in the template and you should then delete the second last line of the code.

Article contributed by Doug Robbins
Word MVP Site

Microsoft Knowledgebase:
Macro to Increment Invoice Number to New Form Document

WordTips:
Sequentially numbered Labels

Here's a further discussion including methods to create sequential ticket numbers:

Here's the PDF version:
Word Field Codes Revealed



See all Topics
word

Labels: Documents, Fields, Formatting, Tutorials

Your own #10

GMayor.com:
ChangingWord Envelope Layouts
Graham Mayor

PC Magazine.com
Custom Envelopes in Word

Microsoft Support:
Create individual envelopes and labels
40 minute lesson

About.com:
Customizing Envelopes with Pictures

Slipstick.com:
Printing Labels or Envelopes for Contacts
Inserting Addresses into Microsoft Word Documents

"One of the advantages to using Microsoft Exchange or Microsoft Outlook is the ability to use information from the Address Book in Microsoft Word documents. Exactly how to do it, though, isn't obvious. The key is an AutoText entry called AddressLayout. This article shows you how to change this entry and how to add an Insert Address button to the Word toolbar."

From Answers.com:

"USAGE NOTE The word envelope was borrowed into English from French during the early 18th century, and the first syllable acquired the pronunciation (on) as an approximation to the nasalized French pronunciation. Other similar words borrowed from French in the modern period include envoy (17th century), encore, ennui, ensemble, entree (18th century), entourage, and entrepreneur (19th century). Most retain their pseudo-French pronunciations, with the exception of envoy, which, like envelope, is mainly pronounced with (en) now."

Labels: Customize, Tips

Clean it up

Also see:
Charles Kenyon's Word Users Guide:

Confidentiality and MetaData in Word Documents

Microsoft downloads:
Office 2003/XP Add-in: Remove Hidden Data
With this add-in you can permanently remove hidden data and collaboration data, such as change tracking and comments, from Microsoft Word, Microsoft Excel, and Microsoft PowerPoint files.

This add-in is not compatible with the 2007 Office system. The Document Inspector feature in the 2007 Office system replaces this add-in. For more information see Office 2007 Resource Kit and the online Help topic.



See all Topics
word

Labels: Documents, Reference, Tips

More typography

Kerning

Adjusting (increasing or decreasing) the space between adjoining type characters.

Kearning pair

Two adjoining type characters to which a particular kearning value is applied.

Kearning value

The space between two adjoining type characters. This value is usually measured in em.

1. Select the text you want to change.
   
2. On the Format menu, click Font, and then click the Character Spacing tab.
   
3. Do one of the following:
   
   • Expand or condense space evenly between all the selected characters
     
     Click Expanded or Condensed in the Spacing box, and then specify how much space you want in the By box.
     
     
   • Kern characters that are above a particular point size
     
     Select the Kerning for fonts check box, and then enter the point size in the Points and above box.

Note: Selecting Expanded or Condensed alters the spacing between all selected letters by the same amount. Kerning alters the spacing between particular pairs of letters.

Microsoft Typography:
A Disagreeably Facetious Type Glossary

WebStyleGuide.com:
Webstyle Guide - Typography

About.com:
Typography Tutorials

Typographica
a journal of typography featuring news, observations, and open commentary on fonts and typographic design.
Here's the RSS connection:
Typographica Feed



See all Topics
word

Labels: Fonts, Formatting

Mail merging creates multiple copies of the same document and inserts data from an external file or database. For example, printing a form letter for different recipients and including each recipient's name.
Word mail merge

FAQ about the mail merge feature in Word 2003 and in Word 2007 will help you learn how to use Mail Merge to create form letters, mailing labels, envelopes, or catalogs. It can also help you troubleshoot problems; and provides step-by-step instructions.

The Word MVP site has some more suggestions.

About.com:
Mail Merge
Creating Documents With Mail Merge

Cindy Meister:
Mail Merge FAQ



See all Topics
word

Labels: Merge

Custom layout

Microsoft Knowlegebase:
HOW TO: Modify the Layout of an Address Book Entry



See all Topics
word

Labels: Customize, Inserts, Reference, Tips

List maker

1. Open Word.
   
2. Use Alt+F11 to open the Visual Basic editor.
   
3. Choose Insert>Module from the Menu.
   
4. Copy and Paste this code in the module.
   
5. Return to Word and go to: Tools>Macro>Macros.


6. Select and run "InstalledFonts".

Sub InstalledFonts()

Dim F As Integer
Dim InstalledFonts As Table

  'Open a fresh document

Set FreshDoc = Documents.Add

   'Create a table and define the header

Set InstalledFonts = FreshDoc.Tables.Add(Selection.Range, FontNames.Count + 1, 2)
With InstalledFonts
.Borders.Enable = False
.Cell(1, 1).Range.Font.Name = "Arial"
.Cell(1, 1).Range.Font.Bold = 1
.Cell(1, 1).Range.InsertAfter "Font Name"
.Cell(1, 2).Range.Font.Bold = 1
.Cell(1, 2).Range.InsertAfter "Example"
End With

   'Loop through all the fonts and add them to the table

For F = 1 To FontNames.Count
With InstalledFonts
.Cell(F + 1, 1).Range.Font.Name = "Arial"
.Cell(F + 1, 1).Range.Font.Size = 10
.Cell(F + 1, 1).Range.InsertAfter FontNames(F)
.Cell(F + 1, 2).Range.Font.Name = FontNames(F)
.Cell(F + 1, 2).Range.Font.Size = 10
.Cell(F + 1, 2).Range.InsertAfter "ABCDEFG abcdefg 1234567890 &$@"
End With
Next F
   'Sort the names of the fonts

InstalledFonts.Sort SortOrder:=wdSortOrderAscending

End Sub

Labels: Fonts

Publisher/Word

..."Word is ubiquitous. If you buy a new computer, chances are good that it will come with some version of Office or Works Suite (which includes Word) installed. Word is a powerful word processing program that incorporates many of the features of a page layout application, but there are times when a page layout or desktop publishing application is what is needed. If you are using the Small Business Edition of Office 97 or Office 2007, Professional, or Ultimate, you have such a program: Microsoft Publisher.

...even if you use only Word, Publisher can be useful to you. Because once upon a time, at least, it came with an excellent manual. The Microsoft Publisher 97 Companion is a 328-page book (compare this to the 19 pages devoted to Publisher in Discovering Microsoft Office 2000 Premium and Professional), and it contains much material that can be equally helpful to Word users.

For example, the chapter "The Look of Words" discusses what fonts are, how to choose them, and how to get the most from them. The following tips, guidelines, and rules of thumb are excerpted from that chapter [with some comments interspersed]. We have not attempted to reproduce all the illustrations that appear in the actual manual, but even the text alone is helpful."

Labels: Formatting, Tips

M-N-Hyphen

There are three kinds of dashes, each a bit longer than the other.
You don't need to put spaces before or after dashes (in the US).

Use the hyphen (-) for hyphenating words.

Use the en dash (–) where you would use "to," as in "business hours are 10 A.M. – 5 P.M.," in a range of numbers (pages 17–25), or to link certain compound adjectives like "the Tokyo–Hong Kong flight" or "anti–blood clotting serum."

Use the em dash (—) instead of parentheses—as is done here—to set off a parenthetical phrase. On the typewriter, two hyphens stood in for this dash.

Labels: Formatting, General, Reference, Tips, Tutorials

Stick it in Word

Arrange the windows so that both applications can be seen.
(Right-click an empty area of the Task bar and choose "Tile Windows Vertically."

Type your introductory text in the Word document.

Switch to PowerPoint and open the PowerPoint file.

In Slide Sorter View, hold down the Ctrl key and select the slides you want to include.

Drag the selected group of slides onto the Word document.

You will only see the first slide in the document, but if you double-click on the image, the PowerPoint show will run.

It will also work in Excel.

(This, of course assumes that the target machine has PowerPoint or PowerPoint Viewer installed)



See all Topics
word

Labels: Inserts, Tips

Without reservations

Labels: Formatting, Tables, Tutorials

CAPS - No - caps

You can make changes to selected text by going to
Format>Change Case
and choosing the correct style. (Including tOGGLE cASE)

You could also use a keyboard shortcut.
Select the text and then hold down the SHIFT key and tap the F3 key to toggle through three of the main cases – All Cap, Lowercase, and Title.

SAP Design Guild:
Quick Guide to Capitalization in English

Technical Communicators' Forum:
Capitalization of Headings and Titles

From The Editorium.com:
Here's a macro to change Heading styles to true Title case:
TITLE CASE MACRO, VERSION 2
By Jack M. Lyon

Word Tips:
Capital after colon

Automatically correct capitalization in most any MS 2007 App.



See all Topics
word

Labels: Formatting

Clean up tools

"When you save Web pages format with Microsoft Word, additional tags are added so that you can continue to use the full functionality of Word to edit your content.

To reduce the size of Web pages, you can save them in filtered HTML. Filtered format removes Microsoft Office-specific tags. If you save in filtered HTML and then reopen the file in Office programs, text and general appearance will be preserved, but some features may work differently.

If you reopen a Web page in Word that you saved in filtered HTML, your text and general appearance are preserved, but you may not be able to use certain Word features in the usual way to edit your files. For example, the appearance of bulleted or numbered lists is preserved; however, some of the Word functionality associated with lists will not be preserved.

If you will need to edit the file later, you can maintain two files: one in Word format and one in filtered HTML format. You can edit the content in the Word document, save it in Word format for future editing, and then save a copy in filtered HTML format."

Labels: Formatting, General

A suggestion I don't suggest

1. On the Tools menu, click Options, and then click the Edit tab.
   
2. Under Editing options, select the Keep track of formatting check box, if it is not already selected.
   
3. Under Editing options, select the Mark formatting inconsistencies check box.
   Formatting inconsistencies will be marked with blue, wavy underlines.
   
4. Click OK.
   
5. In your document, right-click the blue, wavy underline where a formatting inconsistency has occurred.
   
6. Do one of the following:
   To correct the inconsistency, click the command that describes the inconsistency.
   To have Word remove the blue, wavy underline and not correct this inconsistency, click Ignore Once.
   To skip all occurrences of the inconsistency in the document, click Ignore Rule.

PC World:
Word 2002 adds fast formatting for stylin' documents.

ShaunaKelly.com:
How the Styles and Formatting pane works in Microsoft Word 2002 and 2003

I would suggest that you don't use this feature. See:
Runaway Styles in 2003

If you are going to use it, just to track formatting, remember to turn it off for the majority of uses.

Also see Wopr lounge



See all Topics
word

Labels: Formatting, Tips

Pre-defined locations

This macro, for instance, changes the text in just the header of the first section:

Sub HeaderFooterObject()
  Dim MyText As String
  MyHeaderText = "This would be your text"
  With ActiveDocument.Sections(1)
   .Headers(wdHeaderFooterPrimary).Range.Text = MyHeaderText
  End With
End Sub

When you use Edit>Replace in Word, it does a fine job of locating all occurrences of the target in the body of the document or in the header or footer.

Something fails, however, when you record the action and try to run it as a macro. To make it work, you must loop through the built in ranges of a Word document.

The exercise is interesting if only for the exposure to the built in ranges such as:

• wdCommentsStory
  
• wdEndnotesStory
  
• wdEvenPagesFooterStory
  
• wdEvenPagesHeaderStory
  
• wdFirstPageFooterStory
  
• wdFirstPageHeaderStory
  
• wdFootnotesStory
  
• wdMainTextStory
  
• wdPrimaryFooterStory
  
• wdPrimaryHeaderStory
  
  and
  
• wdTextFrameStory.

See this article for more information:

Word.MVPS.org:
Find and replace with VBA

Also:

Microsoft KB
VBA macro examples to insert text into a document



See all Topics
word

Labels: Macros, Tips, Tutorials, VBA

Or do you love it?

" This study sought to determine if certain personalities and uses are associated with various fonts. Using an online survey, participants rated the personality of 20 fonts using 15 adjective pairs. In addition, participants viewed the same 20 fonts and selected which uses were most appropriate.

Results suggested that personality traits are indeed attributed to fonts based on their design family (Serif, Sans-Serif, Modern, Monospace, Script/Funny) and are associated with appropriate uses.

Implications of these results to the design of online materials and websites are discussed."

Labels: Fonts, Formatting