More macro help....

daniel · Post by **daniel** » Tue Jan 23, 2007 10:57 pm

I'm trying to create a macro that if a person is keying and they enter, for example, 99999999 this macro would give them a dialog box. Basically what I need the macro to do is begin running automatically when that person logs in and continue running until they log off.

Any ideas?

thanks.

pgriffin · Post by **pgriffin** » Wed Jan 24, 2007 5:40 am

hmmmmm......what are you trying to do with this macro? It helps us to help you if you state a business problem you are trying to solve.

daniel · Post by **daniel** » Wed Jan 24, 2007 1:55 pm

What I'm trying to do is if a person keying keys nine 9's (999999999), I want a message box to appear and instruct the keyer to run a macro.

If that person clicks on the OK button, I still want the macro to continue running because it might happen multiple times throughout the day.

Me_again · Post by **Me_again** » Wed Jan 24, 2007 2:39 pm

Keys 999's into a specific application, or just into anything, email, google, whatever?

daniel · Post by **daniel** » Wed Jan 24, 2007 3:28 pm

I would prefer the 9999s into a specific application but if that's not possible than I can use the 999s into any other program. Basically they would only be keying the 999s in a certain application so if we have to put it for all applications and all the would have to do is click OK to get rid of the box, that that's fine with me.

thanks in advance.

daniel · Post by **daniel** » Wed Jan 31, 2007 3:20 pm

Anymore help on this topic???

Post by **Marcus Tettmar** » Wed Jan 31, 2007 3:34 pm

Why 9 9s?

daniel · Post by **daniel** » Wed Jan 31, 2007 6:39 pm

Because entering nine 9s into a field is a way for us to make this field a generic field. Once we do that than we need to erase data from another location. This step can be done manually and with a macro, but if a person is doing it manually we need something to let them know not to forget the other fields that need to be deleted.

So basically what I need is to setup a macro that is continuously running and when nine 9s get entered in a row a message box will appear.

Post by **Marcus Tettmar** » Fri Feb 02, 2007 4:37 pm

I would create a looping script that constantly checks the value of this field. The script would have to run continuously in the back ground. To check the value of the field either use GetControlText, or, if necessary, send ctrl+c to the field to copy to the clipboard and then use GetClipBoard to read the value into a variable. The script could be written in such a way that it only does the check if the window containing the field was active. It would loop continuously and when it sees that the value is 999999999 invokes the code you want to perform ... and then starts checking again.