Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2016, 05:05 AM
eiol eiol is offline Import autotext from a table? Windows 7 64bit Import autotext from a table? Office 2007
Novice
Import autotext from a table?
 
Join Date: Aug 2015
Posts: 3
eiol is on a distinguished road
Default Import autotext from a table?

I have a large document (over 100 pages) with text I want to import into the auto text.



is there someone who has a macro for this?

thanks in advance.

eiol
Reply With Quote
  #2  
Old 01-06-2016, 06:08 AM
gmayor's Avatar
gmayor gmayor is offline Import autotext from a table? Windows 10 Import autotext from a table? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You'll have to provide more detail about the document, how it is formatted and how you want to employ it as autotext, before anyone can suggest a macro.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 01-06-2016, 09:25 AM
Charles Kenyon Charles Kenyon is offline Import autotext from a table? Windows 8 Import autotext from a table? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,136
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

See Greg Maxey's Building Blocks Tools. You may have to reformat your table or move the contents into one formatted for that utility.
Building Blocks & AutoText The download from that page includes a Building Blocks loader on the left end of the ribbon.
Reply With Quote
  #4  
Old 01-07-2016, 03:18 AM
eiol eiol is offline Import autotext from a table? Windows 7 64bit Import autotext from a table? Office 2007
Novice
Import autotext from a table?
 
Join Date: Aug 2015
Posts: 3
eiol is on a distinguished road
Default

This is what i want to do:

Table with two collumns. at the one side the short text and at the other collumn the Whole text that i want to import to the autotext gallery.

As in the attachment.


i have seen another code that have the same function, but this import the texts into the auto correct list.

Sub MultiAutoCorrectGenerator()
' Adapted by Greg Maxey from MultiFindAndReplace code provided by Doug Robbins
Dim oDoc As Document
Dim i As Integer
Dim Wrong As Range
Dim Right As Range

Set oDoc = ActiveDocument
For i = 2 To oDoc.Tables(1).Rows.Count
If oDoc.Tables(1).Rows(i).Cells(1).Range.Characters.C ount > 1 Then
Set Wrong = oDoc.Tables(1).Cell(i, 1).Range
Wrong.End = Wrong.End - 1
Set Right = oDoc.Tables(1).Cell(i, 2).Range
Right.End = Right.End - 1
AutoCorrect.Entries.Add Name:=Wrong, Value:=Right
End If
Next i
End Sub



Is it possible to make something like this to import the texts to autotext instead?
Attached Images
File Type: jpg Uten navn.jpg (52.2 KB, 15 views)
Reply With Quote
  #5  
Old 01-07-2016, 03:58 AM
eiol eiol is offline Import autotext from a table? Windows 7 64bit Import autotext from a table? Office 2007
Novice
Import autotext from a table?
 
Join Date: Aug 2015
Posts: 3
eiol is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
See Greg Maxey's Building Blocks Tools. You may have to reformat your table or move the contents into one formatted for that utility.
Building Blocks & AutoText The download from that page includes a Building Blocks loader on the left end of the ribbon.

Unfortunately this is no solution that I can use, then it is not allowed in our business
Reply With Quote
  #6  
Old 01-07-2016, 05:34 AM
Charles Kenyon Charles Kenyon is offline Import autotext from a table? Windows 8 Import autotext from a table? Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,136
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

If you need to write your own macro, try using Google.
"load autotext vba"
Reply With Quote
Reply

Tags
autotext, macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
Import autotext from a table? Import data from CSV to table gebobs Excel Programming 4 10-20-2014 04:40 PM
Import autotext from a table? How do I edit AutoText? TommyVincent Outlook 2 08-01-2014 08:20 AM
Import autotext from a table? Autotext jafrapatty Word 2 05-09-2014 04:30 AM
Import autotext from a table? Inserted AutoText table incorrectly formatted - unless macro paused! Smallweed Word VBA 4 01-16-2014 03:15 PM
Maintaining AUtotext Entries from an external table. kelzud Word Tables 0 07-28-2009 01:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft