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