Export of Autotext Entries to Excel using VBA / macro

[John Falloon]

We have several support staff who have autotext entries in their
normal.dot template file which is stored locally on their computer.

We have started a Commission wide contact management program to
"consolidate" corporate information.

We would like to find a way to:

1. using vba / macros to export autotext entries from users normal.dot
template and save the entries as Excel spreadsheet(s). Two columns -
one column the autotext entry and the second column the autotext
value.

Can anyone start me in the right direction?

Thanks again.



John Falloon
Technical Analyst
B.C. Securities Commission
Vancouver BC Canada
Email: (e-mail address removed)

 

[Jezebel]

The short answer is, you simply iterate the AutoTextEntries collection:

with WordApp.NormalTemplate.AutoTextEntries
for i = 1 to .Count
.Name ....
.Value ....
next
end with

Bear in mind that Autotext values are not necessarily text that will make
sense in a spreadsheet: they may include graphics, Word fields, and Word
formatting.