Keyboard Short Cuts

[flynjack]

This sounds simple, but I can't figure it out.

I have query that, after run, provides all of the info I need.

Here's my problem.

I want to simply "Select All" records, "Copy" these records, do an "ALT+TAB" (Or prefereably be able to have it slect the application i want to paste in), and then finally a "Paste".

Sounds easy enough. My fingers allow me to do it on the keyboard, but my brain doesn't allow me to do it VBA.

Can anyone give me the format for the VBA code to do just this. Thanks.

Flynjack

 

[chergh]

What are you trying to paste into?

 

[flynjack]

I'm pasting into a program called "Zilan". Hope this helps.
Thanks
flynjack

 

[chergh]

thought it might have been excel in which case it would have been easy.

You could use send keys

SendKeys "^C"
SendKeys "%{TAB}"
SendKeys "^V"