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

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

rfusee wrote:
>
> 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

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" wrote:

> Did you at least try the code from Chip Pearson's site?
>
> rfusee wrote:
> >
> > 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
>

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.

rfusee wrote:
>
> 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" wrote:
>
> > Did you at least try the code from Chip Pearson's site?
> >
> > rfusee wrote:
> > >
> > > 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
> >

--

Dave Peterson