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 -