Copying Text to Clip Board Using a Macro

[robertguy]

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

 

[Oliver Ferns via OfficeKB.com]

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

 

[robertguy]

Oli


it would not more than a couple of lines of text



Rob

 

[Dave Peterson]

Chip Pearson has some notes about working with the clipboard at:

http://www.cpearson.com/excel/clipboar.htm