Macro to record mouse clicks in external data source

[bpower2]

Hello all-- I'm sorry if this has been answered, but I can't find the answer to this anywhere on the internet. I am trying to record a macro that records the mouse clicks in an application outside of excel. I don't believe this can be accessed by doing a data query b/c to login into the application you need username/password/biometric fingerprint. Is there any particular way to have Excel macros record my keystrokes and mouse clicks in this external app then pasting into Excel? I feel like this probably isn't possible but figured I don't really know too much hah.

Any help would be greatly appreciated. Thanks very much.

 

[VoG]

I don't think that will be possible.

To interact with an application outside of Excel you could try the SendKeys method http://msdn.microsoft.com/en-us/library/aa202943(v=office.10).aspx although it can be unreliable.