![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hi there,
I am a medical transcriptionist with very little programming experience, but have written a series of macros to copy/paste Word reports into my client's Word-based document. Unfortunately, although I've written some steps into the macro which would make it difficult to paste one patient's report into the wrong patient's demographics, it has still happened. When part 1 of the macro runs, this is how the patient info lines look: Correct: 32460 reagan xr chest (obtained from demographics in client's header) 32460 reagan xr chest (from our typed report) Incorrect: 32460 reagan xr chest 42460 reagan xr chest As you can see, in the Incorrect sample, the numbers don't match. From what I've gathered so far, I need to insert the two patient info lines into a table and have the program abort if the A1 cell of the table doesn't match the A2 cell. I would like the macro to "ABORT" if it doesn't match and proceed with the rest of the macro if it does match. I would really appreciate any help I can get. Thanks a lot! -- -- hometeamjill ![]() |
Ads |
#2
|
|||
|
|||
![]()
This is an Outlook group. Post this question in a Word group.
-- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm "hometeamjill" wrote in message ... Hi there, I am a medical transcriptionist with very little programming experience, but have written a series of macros to copy/paste Word reports into my client's Word-based document. Unfortunately, although I've written some steps into the macro which would make it difficult to paste one patient's report into the wrong patient's demographics, it has still happened. When part 1 of the macro runs, this is how the patient info lines look: Correct: 32460 reagan xr chest (obtained from demographics in client's header) 32460 reagan xr chest (from our typed report) Incorrect: 32460 reagan xr chest 42460 reagan xr chest As you can see, in the Incorrect sample, the numbers don't match. From what I've gathered so far, I need to insert the two patient info lines into a table and have the program abort if the A1 cell of the table doesn't match the A2 cell. I would like the macro to "ABORT" if it doesn't match and proceed with the rest of the macro if it does match. I would really appreciate any help I can get. Thanks a lot! -- -- hometeamjill ![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word macro warning | goran | Outlook and VBA | 1 | December 21st 07 09:44 AM |
retrieving Outlook user info from Word macro | IndianSummer | Outlook and VBA | 1 | September 29th 07 12:05 AM |
If then statement | Aggie G | Outlook - Using Forms | 3 | February 2nd 07 07:50 PM |
Outlook macro abends but Word macro runs successfully | Jreue | Outlook and VBA | 0 | December 13th 06 11:55 PM |
Macro to search for word | Dave Neve | Outlook and VBA | 7 | July 26th 06 09:52 PM |