Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Modifying a recorded macro in Word 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CBritton - 09 Jan 2008 17:16 GMT
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 Jollans - 09 Jan 2008 19:00 GMT
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.

Signature

Enjoy,
Tony

>I began a small project that involved the following steps:
> 1. Copy a large amount of table data from my health insurer's site.
[quoted text clipped - 15 lines]
> 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 - 10 Jan 2008 14:11 GMT
Thanks Tony, I will give that a try.

> 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
[quoted text clipped - 21 lines]
> > 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.