| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting into another application usin Excel VBA
Is there any way to paste data from the clipboard into another program using a command button in VBA for excel ? I want to be able to paste information from Excel to .. say ..an already open and running notepad ... without having to click over to notepad. Any idea if this is possible ? I know those smiley programs can paste into other applications .. just not sure if excel vba can handle it. thanks for the help. -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=496617 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting into another application usin Excel VBA
If you cannot create a reference to the object to which you want to paste,
you can always use the sendkeys method in Excel. -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "SystemHack" wrote: Is there any way to paste data from the clipboard into another program using a command button in VBA for excel ? I want to be able to paste information from Excel to .. say ..an already open and running notepad .. without having to click over to notepad. Any idea if this is possible ? I know those smiley programs can paste into other applications .. just not sure if excel vba can handle it. thanks for the help. -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=496617 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pasting into another application usin Excel VBA
If you want to put your data in a text file, that can be done pretty easily.
(then you could open it in Notepad using the Shell command) If you actually want to paste it in Notepad, then you can look at the sendkeys command. -- Regards, Tom Ogilvy "SystemHack" wrote in message ... Is there any way to paste data from the clipboard into another program using a command button in VBA for excel ? I want to be able to paste information from Excel to .. say ..an already open and running notepad . without having to click over to notepad. Any idea if this is possible ? I know those smiley programs can paste into other applications .. just not sure if excel vba can handle it. thanks for the help. -- SystemHack ------------------------------------------------------------------------ SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614 View this thread: http://www.excelforum.com/showthread...hreadid=496617 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formatting when pasting from a non-Office application | Excel Discussion (Misc queries) | |||
| ADD MONIES USIN EXCEL SPREAD SHEET | New Users to Excel | |||
| Application activation and pasting | Excel Programming | |||
| Usin Picture on userform | Excel Programming | |||
| How to create Excel, Access and dbf output files from DataSet usin | Excel Programming | |||
![SystemHack[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
