View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Shortcut for Paste Special Values

I have a wild haired idea. (Wild haired? Hair Brained? Wild Eyed?)
ANYWAY, is there a way in VBA I can test what kind of contents are in
the clipboard? I was thinking if I copied something like formulas or
Access data or some other where I want the results pasted as CSV, I
could use just the standard paste command and then have the code test
what I'm pasting and automatically paste it as CSV if it meets the
criterion. Should I just be quiet and go back to playing with my
little numbers, or could something like that work? Or does it already
exist and I just don't know it?

tod