G
Guest
I am trying to transform text outputted from an old legacy "roll and scroll"
database system to a table in Word. Search and replace are not adequate. I
need to do multiple searches for colons, copy text from one field to a table
in another document, return, search to the next colon, copy text, etc.
There are over 700 pages of this data. I would like to record one macro
action to copy one complete record, then add a loop to get it to repeat the
data extraction/copying for the rest of the records in the doc.
Do I simply add the loop statement to the end of the macro? The Repeat
Action command did not work. I just want to run the same macro over and over
from the current cursor location.
Any ideas are much appreciated!
database system to a table in Word. Search and replace are not adequate. I
need to do multiple searches for colons, copy text from one field to a table
in another document, return, search to the next colon, copy text, etc.
There are over 700 pages of this data. I would like to record one macro
action to copy one complete record, then add a loop to get it to repeat the
data extraction/copying for the rest of the records in the doc.
Do I simply add the loop statement to the end of the macro? The Repeat
Action command did not work. I just want to run the same macro over and over
from the current cursor location.
Any ideas are much appreciated!