Calling all Computer Wizards!!!!!

Got a spreadsheet. Contains Usernames, First Names, Last Names, Middle Initials. I want to run a macro (Mouse and Key Recorder) to type in this stuff into our EMR program.

So I have the script for the macro which I will post. But is there any way I can easily take this list of 400 users and get it to blow into the macro code. Like John A Smith have his info blown in and then the next person in line into the same code? Possible? No? Depending on the amount of work involved, I may dish out some money. That is right REAL DAMN MONEY!

Macro Code

jma55 (Username)
{ENTER}
{ENTER}
{TAB}
{TAB}
Jeremiah (1st Name)
{TAB}
M (MI)
{TAB}
Abue MD (Last name + Title)
{TAB}
{TAB}
{TAB}
{TAB}
{TAB}
{TAB}
{TAB}
DCM (initals)
{TAB}
Y
{TAB}
^c
{{Mouse 1, 1, 871, 9, 0
^v
{DOWN}
{{Mouse 1, 1, 564, 761, 0

{TAB}
{TAB}
{TAB}
{TAB}
S
{F9}
{DOWN}
{DOWN}
{ENTER}
{{Mouse 1, 1, 804, 184, 0

PS. I am an idiot. Move to T-T-T-T-Tech Myself if needed.

Quick and dirty method write an Excel VBA macro that reads the list from one sheet, and dumps the macro code for each person line-by-line on another sheet. Then export that sheet as a text file to feed into your macro program. Off the top of my head I think that should work.

You might also check out AutoHotKey[=http//www.autohotkey.com]AutoHotKey. It's free and scriptable to do all sorts of automation. Don't know if it's better/worse than the one you're using, but it's popular in the online poker community for modding/automating poker client software.

Yeah I think thats my option.

Do you know of a way to take say a text field with abc123 and format it to only show the abc part? (Something that would just delete the numbers) DONE with WORD.

And what is the easiest way to attach MD to 400 last names? Replace is not working....

[quote2bac02d52f="TryinToGetPaid"]Do you know of a way to take say a text field with abc123 and format it to only show the abc part? (Something that would just delete the numbers)[/quote2bac02d52f]
Should be easy with a string parsing/replacement function or two in VBA. Just index over the string until you reach a non-alpha character, then substring from the beginning to that index.

[quote2bac02d52f="TryinToGetPaid"]And what is the easiest way to attach MD to 400 last names? Replace is not working....[/quote2bac02d52f]
I don't think Excel's standard replace is sophisticated enough to use something like regular expression replacements, so outside of exporting the data to something that can do that, then re-importing, you could write a VBA macro for that too. Or just include it in the VBA macro you're writing to generate the macro code.

I think I got it. Dmo. You rock. And YAY for automated working. It works, I sleep and earn cash.

YAYYYYYY

http//www.shopcomputerwizards.com/WIZARDS/IMAGES/Logo/new%20logocopy2%20copy.gif[" alt=""/imgd49858deae]