Cut and paste issue

[Guest]

Hi all,

I've distilled a previous problem that I posted down to something very
simple, however I still can't figure it out!!! Here's the deal...

In any cell, type in this....

Line 1 <then hit alt-Enter to do a carriage return>
Line 2

If you cut and paste this into Notepad or Access, you get this:

"Line 1
Line 2"

I need to figure out how to get those quotes out of there...

 

[Dave Peterson]

Did you at least try the code from Chip Pearson's site?

 

[Guest]

Hi Dave,

I didn't at first because it wasn't going to work for my use case. I'm
spitting out a couple dozen of these and the sales folks are going to cut and
paste the ones they need into contracts. If I moved them all right to the
clipboard it wouldn't work.

At any rate, I went ahead and tried to implement it just for my own
knowledge and I couldn't define a New DataObject so I kind of got stuck...

 

[Dave Peterson]

Make sure you set that reference (tools|References) that Chip describes on that
web page.

Maybe you could give them a macro that calls that code--either a button on the
worksheet or even a shortcut key.