I have an Excel/VBA macro in which I want to record the screen using Camtasia Studio's Recorder. You just hit F9 and the Recorder grabs a frame. When I try to do this from the macro (below), the application is activated but nothing happen from the SendKeys command. Any ideas?


AppActivate "Camtasia Recorder"
SendKeys "{F9}", True

Sometimes, what I've noticed is that the application needs time to complete it's focus. If the application takes time, the Sendkeys statement could be finishing before the application is ready for it. Since this is asynchronous, you'll need to put a small timer in your code such as For i = 1 to 10000000:Next (the value depends on how fast your computer is, so you'll have to tune this through debugging).

This isn't perfect and it would be better if you had a way to return a state from the application opening up before executing your Sendkeys statement, but I am still learning how to do that.

This is an alternative although we can only go down to 1 second delay :-
-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.