MS Word – Adjusting a Form Template

Just got back to having computer access and received a call from my wife. A form I had made up for her, using Microsoft Word 2003, needed adjusting for some new product and she had ten orders to type up and run on the dot matrix printer with the new information.

The problem was that she knows very little about how to use Microsoft Word and needed it done right away to keep from having to do everything by hand.

Luckily, I was able to walk her through sending me a copy of the DOT (Word Document Template (Microsoft)) file, via email. Once I saved that DOT file to my hard drive, I was able to open it, adjust it and email it back to her.

To make the adjustments in MS Word 2003, I did the following:

  • Right clicked on the DOT file.
  • Selected Open from the drop down menu. (If you just double-click a DOT file to open it, you will get a new blank document instead of opening the DOT itself.)
  • Made the Forms Toolbar visible:
  • View on the MS Word menu bar
  • Select Toolbars
  • Click on Forms
  • Clicked on the Protect Forms icon, it looks like a little padlock, to unlock the form.
  • Replaced three text items with Text Form Fields, with the same formatting as the replaced text; also changed text in another area, but straight text not a Text Form Field.
  • Clicked on the Protect Forms icon again to lock the form again.
  • Hid the Forms Toolbar again.
  • View on the MS Word menu bar
  • Select Toolbars
  • Click on Forms
  • Saved the DOT file with a new name, reflecting today’s date and the new function.

Once the form was adjusted, I emailed her the new DOT file and walked her through how to save it in a folder in My Documents containing forms of the same type and then walked her through creating a shortcut for this one to the desktop.

The whole process took about a half hour and saved a lot of work on her part. Now she just needs to double-click on the shortcut item, fill in the information that changes, print the multi-part form on the dot matrix printer, sign it and move on to the next order of business.

She has some other forms, that are not multi-part, but those I have done for her in PDF (Acrobat Portable Document Format) and have to do those differently as you must have the complete Acrobat application to create or adjust them.

If you have special forms or interested in forms, leave a comment and let me know how you handle problems.

As Thursday is Thanksgiving Day, there will be no posting. I will be spending time with my family, as we all should, and will post Friday this week instead.

Have a great Thanksgiving!!

Word – Random Text Generation

I sometimes have to generate some random text to test how a new layout looks for a newsletter or website. I know there are easier, and probably better ways to do it but, here are two methods I have used in Microsoft Word.

The first is to simply locate a document and copy what looks like the right amount of text and paste it into the new layout as plain text.

The second method I use is to randomly generate a number of paragraphs in Word and then copy them and paste them into the new layout as plain text.

To do the generation of random text paragraphs in Word:

  • Create a new blank document.
  • Type =rand(#) [insert 1 for 1 paragraph, 5 for five paragraphs, etc. in the place of #, inside the parentheses].
  • Press enter.

This will insert the following paragraph the specified number of times:

“The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog. The quick brown fox jumps over the lazy dog.”

This is another of those little things, that I seldom think about but, have been asked by others “How do you do that?”.

Open XML Spreadsheet in Excel

I was at my Business Agent’s office the other day and she was emailed a file, which she could not open after saving to her desktop.

The file in question contained spreadsheet information so she was double clicking on the file, thinking it would open up in Microsoft Excel but, it would not open.

She was on the phone with the sender, trying to resolve the problem.

I happened to see that the file had an .xml extension and when she hovered over the file name, the file properties showed it as being an “XML Spreadsheet”. These clues told me that the file had been sent in an XML (EXtensible Markup Language) format, not Microsoft Excel.

I told her to:

  • Open her Excel applications.
  • Go to the File menu.
  • Select Open from the drop down menu.
  • Navigate to the file on her desktop that needed to be opened.
  • Select the file (Change the File Type to All Files, if necessary).
  • Click Open.

This opened the file in Excel and she was able to access the information. I say that she was able to access the information because the XML file only contains the information with minimal set up; she ended up having to go in and setting up the header, footer, repeating row, etc. to manipulate the information.

This worked because she had Excel 2003. From what I have found Microsoft Office 2003 and above includes XML reading capabilities. OpenOffice is also capable of reading XML files.

XML is a much more involved subject than can be handled in a blog like this. Also, I am just now reading about XML and doing a little experimentation on utilizing it.

From what little I have read about XML and its implementation, XML will be more prevelant in the very near future, as the information needs to be written only once and then can be presented in many different ways very easily. For an overview of XML check out this information at the Wikipedia site: Extensible Markup Language.