2 AutoText questions

A

Anita

How can I put a list of autotext entry names from my normal template into an
Excel spreadsheet or a word table. I don't want to just print them out I
want to be able to type notes next to each one.

Also, is there any way that you can create a new group when you click the
All Entries button on the Autotext toolbar. I have about 200 entries under
normal and I want to break them down so they are not all under the normal
heading.

Many thanks.
 
S

Suzanne S. Barnhill

One solution that is often suggested for creating documents via printing is
as follows:

1. Select Generic/Text Only as your printer.

2. Select "AutoText entries" under "Print what."

3. Check the box for "Print to file."

4. When you hit OK, you'll be asked for a filename.

5. A plain text file will be created; you can open this and save it as a
Word document (.doc file) and manipulate the contents any way you like (for
example, you could convert the text to a table, then add another column for
your comments).
 
A

Anita

Hi Charles

Thanks for the answer to the second question. How does the macro work for
the first question?
 
C

Charles Kenyon

I haven't written the macro. It would cycle through the AutoText entries
collection and put the information into a file. You might want to ask for
help writing it in the vba.beginners newsgroup. If possible, I would suggest
a four-column table with one column for the name of the entry, one for the
entry itself, a third for the style or category, and a fourth for the name
of the template holding the entry.
 
S

Suzanne S. Barnhill

I tried this, and I have to agree that its usefulness is limited. Naturally
any graphic AutoText entries are not correctly represented, but Word also
seems to wrap the entries as displayed in the AutoText dialog window and pad
out with spaces. It would probably be more trouble than it was worth to turn
it into anything useful. Sorry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top