View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
sth sth is offline
external usenet poster
 
Posts: 5
Default Capturing text in active cell to clipborad (Excel 95)

Steve, Thx for the attempt but those commands resulted in an error
message: "Object required."

=====

Steve Garman wrote in message ...
It's been a while, but if I recall correctly, there was a Clipboard
object back then.

Have you tried this:

Clipboard.Clear
Clipboard.SetText Range("A1").Text

sth wrote:
My Excel programming skill are not very good, so plz excuse my
ignorance.

Through an Excel macro, I would like to automate capturing into the
clipboard the text in a selected cell. I have tried using
Selection.Copy
command but the app that will be receiving the copied cell returns an
errror message stating that only text can be pasted.

I also tried using this code, which I scavenged from
http://www.cpearson.com/excel/clipboar.htm:


<snip