drdave

Cory. Thanks for your quick reply. Of course you are right but I’ve been building on this group long before I understood the details of huge and involved macros. I was hoping for a short fix, thanks again.

I need some assistance. I have 545 macros that employ a "windows activate" command to an old database. The database name has changed. So I have to go into each macro and edit it using the "Find and Replace all" command each time for 545 times. I have tried to write a macro that would accomplish this goal using a hot key. But it does'nt appear to work. I tried, while in the Macro Express Pro - Explorer, to write a macro that go one-by-one to the next macro below it and: arrow down (to go to the macro below it) enter (to edit the macro) CRTL r (find and replace the two database's names) ALT a (find and replace all) Activate "Replace" box; move mouse to "x" and close "replace box" CTRL l to save and close. I would then have the macro repeat itself 545 times. Some assistance in the best way to accomplish this would be greatly appreciated.

Hi, I'm not sure how to do this. I have two sets of data. In Database 1: I have a person's name (i.e. David Smith) which I assign T72 and a separate Database 2---the same person but with his professional title added (i.e. David Smith RN). I will assign this name+title as T73 . Is there a way to "compare" the two variables [T72 and T73] and then "strip" T72 information out of T73 leaving only the individual's title which I can assign to another variable to manipulate it further.

Thank you, I'll check it on out. Thank you for the speedy reply

How do I go about initially set a string variable and have that variable value increment by one each time I run a repeat macro? (ie.) T1 for first name, T2 for the next name ect. on a list.