Modifying a recorded macro in Word 2003

I began a small project that involved the following steps:
1. Copy a large amount of table data from my health insurer's site.
2. Save the table in a text file to get rid of the table formatting.
3. Copy the resulting text to Word where I could use "Find/Replace" editing
to remove redundant data and formatting.
4. Record a macro of all the Find/Replace steps for later use on data updates.
5. Copy results (now a list of tab delimited records) back to a text file.
6. Import text file into an Excel worksheet.

All this worked fine, except that when I ran the macro from the keyboard I
had to keep pressing the shortcut keys as if the macro was being stepped
through the several code segments.

Not being very accomplished in writing or recording macros, I don't know how
to get the macro to run as a single operation without all the keyboard
intervention. Can anyone offer a solution or a link to same?

Tony
Wed Jan 09 11:00:23 PST 2008

I have experienced this and have seen a few reports of it but, despite some
discussion, have not found an explanation or a resolution. Try shuttimg down
all Office applications and then reopening them and trying agan - if that
doesn't work, maybe rebooting will - if that doesn't, I'm fresh out of
ideas.

--
Enjoy,
Tony

"CBritton" <CBritton@discussions.microsoft.com> wrote in message
news:0E155929-8AB7-45A2-8D14-3875FBBC9ED9@microsoft.com...
>I began a small project that involved the following steps:
> 1. Copy a large amount of table data from my health insurer's site.
> 2. Save the table in a text file to get rid of the table formatting.
> 3. Copy the resulting text to Word where I could use "Find/Replace"
> editing
> to remove redundant data and formatting.
> 4. Record a macro of all the Find/Replace steps for later use on data
> updates.
> 5. Copy results (now a list of tab delimited records) back to a text file.
> 6. Import text file into an Excel worksheet.
>
> All this worked fine, except that when I ran the macro from the keyboard I
> had to keep pressing the shortcut keys as if the macro was being stepped
> through the several code segments.
>
> Not being very accomplished in writing or recording macros, I don't know
> how
> to get the macro to run as a single operation without all the keyboard
> intervention. Can anyone offer a solution or a link to same?
>

CBritton
Thu Jan 10 06:11:03 PST 2008

Thanks Tony, I will give that a try.


"Tony Jollans" wrote:

> I have experienced this and have seen a few reports of it but, despite some
> discussion, have not found an explanation or a resolution. Try shuttimg down
> all Office applications and then reopening them and trying agan - if that
> doesn't work, maybe rebooting will - if that doesn't, I'm fresh out of
> ideas.
>
> --
> Enjoy,
> Tony
>
> "CBritton" <CBritton@discussions.microsoft.com> wrote in message
> news:0E155929-8AB7-45A2-8D14-3875FBBC9ED9@microsoft.com...
> >I began a small project that involved the following steps:
> > 1. Copy a large amount of table data from my health insurer's site.
> > 2. Save the table in a text file to get rid of the table formatting.
> > 3. Copy the resulting text to Word where I could use "Find/Replace"
> > editing
> > to remove redundant data and formatting.
> > 4. Record a macro of all the Find/Replace steps for later use on data
> > updates.
> > 5. Copy results (now a list of tab delimited records) back to a text file.
> > 6. Import text file into an Excel worksheet.
> >
> > All this worked fine, except that when I ran the macro from the keyboard I
> > had to keep pressing the shortcut keys as if the macro was being stepped
> > through the several code segments.
> >
> > Not being very accomplished in writing or recording macros, I don't know
> > how
> > to get the macro to run as a single operation without all the keyboard
> > intervention. Can anyone offer a solution or a link to same?
> >
>
>