App activate issue

[sunspot27]

I'm using the following code to access an application called ACT! that
is open and running and send the following keys. However after the
'AppActivate' line, it reverts back to excel.

Sub test()

AppActivate ("ACT!")
SendKeys ("%f")
SendKeys ("d")
SendKeys ("e")

End Sub


How do i stop this form happening?

Thanks

 

[Bernie Deitrick]

You would need to set an object to the ACT! application, then use ACT!'s methods and objects. If
ACT! doesn't support VBA, then you might be able to use Windows and window handles to direct the
necessary keystrokes - but I have never needed to do that so it will take a little more research on
your part to figure it out.

HTH,
Bernie
MS Excel MVP