Reply
 
Thread Tools Display Modes
  #1   Report Post  
Anita
 
Posts: n/a
Default Put autotext names into txt file or excel file

Is there a way to create a list of my autotext entries from normal.dot in
either a text file or is there a way I can get them into an Excel spreadsheet
(that would be better still).

What I need to do is get the autotext entries in a column so that I can then
write descriptions and notes beside them in the next column.

I would be so grateful if anyone can help, I have tried every resource going.

Anita
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?QW5pdGE=?=,

Is there a way to create a list of my autotext entries from normal.dot in
either a text file or is there a way I can get them into an Excel spreadsheet
(that would be better still).

What I need to do is get the autotext entries in a column so that I can then
write descriptions and notes beside them in the next column.

It would require a macro. Here's some sample code, to get you started. It's not
clear from your problem description whether you want the entries' names listed,
or their content. The macro lists the content. If you want the name, change
Value to Name, below.

Sub WriteAutoTextToTable()
Dim tbl As Word.Table
Dim AT As Word.AutoTextEntry
Dim rw As Word.Row

Set tbl = ActiveDocument.Tables.Add( _
Range:=Selection.Range, NumRows:=1, NumColumns:=2)
tbl.Cell(1, 1).Range.Text = "AutoText entry"
tbl.Cell(1, 2).Range.Text = "Description"
CustomizationContext = NormalTemplate
For Each AT In NormalTemplate.AutoTextEntries
Set rw = tbl.Rows.Add
rw.Cells(1).Range.Text = AT.Value
Next
End Sub

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I save my AutoText file to transfer it to another PC? kd1s Microsoft Word Help 3 September 21st 05 07:39 AM
macro to save rtf file as txt reballdad Microsoft Word Help 1 December 20th 04 10:17 PM
Are there any characters not allowed in file names now? fbowles Microsoft Word Help 2 December 8th 04 11:45 PM
I can't merge with excel spreadsheet OR tab delimited word file Trudi Microsoft Word Help 3 December 4th 04 10:53 PM
File missing when loading by association Bad Horsey Microsoft Word Help 1 November 30th 04 06:33 PM


All times are GMT +1. The time now is 10:25 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"