Simple Sendkeys alternative?

[travisc]

The application i'm trying to sendkeys to is only allowing standard text/numbers. Special characters such as (TAB, ALT, F7, etc) are not registering. Looking for another VBA alternative to try? All the program is doing is switching to the application, which works fine. And entering 2 [TAB]s and the number 1, and looping X amount of times.

Sub CycleCount()
    Dim cycles As Integer
    Dim counter As Integer
    counter = 0
    cycles = InputBox("How many line items to count?")
    If cycles = 0 Then Exit Sub
    AppActivate "e21prd"
    SendKeys "1", True
    For counter = 1 To cycles
        SendKeys "{TAB 2}1", True
        Next counter
    MsgBox "Complete"
End Sub

Thanks in advance.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Simple SendKeys alternative?
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[travisc]

I apologize, i didn't realize mrexcel.com and excelforum.com were the same site.

 

[Fluff]

We aren't, if you follow the link supplied in the rules uou will understand.