If matches, then...

  • Thread starter Thread starter hometeamjill
  • Start date Start date
H

hometeamjill

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!
 
a series of macros to copy/paste Word reportsThis is a newsgroup for Access, a relational database program that is part
of Microsoft Office Professional. It is unclear as to what application you
are using - Word, Excel, or Access.
 
Back
Top