| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Copying Text to Clip Board Using a Macro
Hi, is it possible to store text e.g. a standard script which I constantly use within the code of a macro ? The macro would be assigned to a button and when the button is “clicked on” it would copy this text to the clip board which will then allow me to paste it into another application. Currently this text is stored in a cell and I reference this cell and copy to clip board this way, buy I want to get away from storing text this way. Any help would be grateful appreciates Many thanks Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=345787 |
|
#2
|
|||
|
|||
|
Hi,
Depending on how much text, you could investigate the use of Names to store your text. You could hide the names if you are interested in Secrecy... Alternatively, you could use global variables, or even as a property of the ThisWorkbook class....how much text are we talking here? Hth, Oli -- Message posted via http://www.officekb.com |
|
#3
|
|||
|
|||
|
Oli it would not more than a couple of lines of text Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=345787 |
|
#4
|
|||
|
|||
|
Chip Pearson has some notes about working with the clipboard at:
http://www.cpearson.com/excel/clipboar.htm robertguy wrote: Hi, is it possible to store text e.g. a standard script which I constantly use within the code of a macro ? The macro would be assigned to a button and when the button is “clicked on” it would copy this text to the clip board which will then allow me to paste it into another application. Currently this text is stored in a cell and I reference this cell and copy to clip board this way, buy I want to get away from storing text this way. Any help would be grateful appreciates Many thanks Rob -- robertguy 44 Married two kids ------------------------------------------------------------------------ robertguy's Profile: http://www.excelforum.com/member.php...fo&userid=5963 View this thread: http://www.excelforum.com/showthread...hreadid=345787 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) | |||
| How do I insert a clip art picture into a text box in word 2003 | Excel Discussion (Misc queries) | |||
| Macro Text into Excell | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| copying text into a macro | Excel Worksheet Functions | |||
Hybrid Mode
