Trapping the keyboard event using macro

[VisualBasicHelp]

Hi,

I am trying to create a macro which will activate the application of TOAD which is already open and whenever the user does ALT+Printscreen, it should come in word and paste it.
Actually I could activate the application. Can anybody tell me how to trap the keyboard event, so that I can activate the word and paste it.

Can anybody provide me the code for trapping keyboard event.

Thanks

 

[ETID]

have you tried the onkey event?

 

[VisualBasicHelp]

how is that?

 

[shetlandbob]

look in help for OnKey

Robert Cumming

http://www.consultantengineer.co.uk

 

[VisualBasicHelp]

Actually I got the solution of my previous question. Now through macro of word when I click a button, the control goes to toad, does an ALT+printscreen and comes back to word and paste it.

But again the question arises, since toad has two windows, editor window and a grid window, editor window is where we type the select query and grid window is where the result is displayed.

I would like the macro to scroll the grid window to get the ALT+Printscreen of the remaining columns which is not seen without scrolling.

Can anybody help me in this. I would be really greatful.

Thanks