VBA send Keys

**Formula-seeker** · 03-19-2017, 05:46 PM

Hi all,

can someone please help me in vba code to send data from cell A1:A100 in other application by using sendkeys .

Thanks

**karedog** · 03-19-2017, 11:12 PM

This is worked for me for sending A1:A100 to Notepad.
Assumming Notepad is already opened, then run this macro :

Please Login or Register  to view this content.

**Alf** · 03-20-2017, 03:25 AM

Or you could start "Notepad" with the "Shell" command and do the copying. A small modification of karedog's macro.

Please Login or Register  to view this content.

Alf

Re: VBA send Keys