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

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

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

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