The FreeiPodGuide Forums

[TryinToGetPaid]

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

[TryinToGetPaid]

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

[dmorris68]

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

[TryinToGetPaid]

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

[dmorris68]

[TryinToGetPaid]

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

[JKirk]

YAYYYYYY