Thread: clipboard
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
gabor salai gabor salai is offline
external usenet poster
 
Posts: 4
Default clipboard

[rearanged]

gabor salai wrote :

with "copy/paste" [say some range], does excel use clipboard, or some
internal structure?
after "copy", is it possible to somehow access that buffer [before
"paste"], and to examine it, or even programaticaly select [or apply]


"keepITcool" wrote in message
ft.com...
well...

Clpbrd.exe will tell you what's on the clipboard.
copy a cell and check it out.


thanks, i wanted to access clipboard [or whatever buffer excel employes]
from *within* excel macro, not from clipboard_viewer!

something like:

set myrange=getclipboard.range(1)
value1=myrange.cells(1,2).value

where cells from clipboarded region should count relatively to upper_left
corner of selection captured by "copy"