Cut and paste issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rfusee - 20 Sep 2007 19:02 GMT

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...

Reply to this Message

Dave Peterson - 20 Sep 2007 20:26 GMT

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

> Hi all,
>
[quoted text clipped - 12 lines]
>
> I need to figure out how to get those quotes out of there...

Signature

Dave Peterson

Reply to this Message

rfusee - 20 Sep 2007 21:06 GMT

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...

> Did you at least try the code from Chip Pearson's site?
>
[quoted text clipped - 14 lines]
> >
> > I need to figure out how to get those quotes out of there...

Reply to this Message

Dave Peterson - 20 Sep 2007 22:20 GMT

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.

> Hi Dave,
>
[quoted text clipped - 28 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Rate this thread: