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

--
Message posted via http://www.officekb.com

[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

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