View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Get text from Win Clipboard into VBA variable

Did you find it?

I'm guessing that you did.

Paul Schrum wrote:

Thank you. I do not have that Library.

On Feb 11, 4:23 pm, Dave Peterson wrote:
Read the first paragraph on Chip's site.





Paul Schrum wrote:

Thanks for your response. When I tried the code on that page I got


Compile error:
user-defined type not defined


I think this means I have to set a Reference to a certain library, but
I can't figure out which one. Do you know how I get around this?


On Feb 11, 3:57 pm, Gary''s Student
wrote:
http://www.cpearson.com/excel/clipboard.aspx
--
Gary''s Student - gsnu201001


"Paul Schrum" wrote:
VBA in Excel 2007


I have data on the clipboard of a specific format:


Start: (') (915855.639280, 638485.145786)
End: (') (917162.295718, 637714.747829)


I would like to bring this from the windows clipboard into a variable
in which I can parse it (to extract and use the coordinates). I can't
find this when I search groups and whatnot. Can anyone help me with
this?


- Paul
Schrum
Raleigh, NC
.- Hide quoted text -


- Show quoted text -


--

Dave Peterson- Hide quoted text -

- Show quoted text -


--

Dave Peterson