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