Modifying a recorded macro in Word 2003

C

CBritton

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?
 
T

Tony Jollans

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.
 
C

CBritton

Thanks Tony, I will give that a try.


Tony Jollans said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top