OK, I simplified my problem a bit, smart people sound off!!!!!

[Guest]

Guys,

3rd post on this now, and I have narrowed my problem down to this:

Function test () as String

test = "line1" & vbLf & "line2"

End


This function shows this in my Excel cell...

line1
line2

If I cut and paste it into notepad, it shows this...

"line1
line2"

I need to get rid of those quotation marks. If I take the vbLf out, i get
line1line2 and when I cut and paste there are NO quotation marks, so I know
it has to do with the fact that I put in the vbLf.

Is there ANY way I can still have my text formatted with carriage returns
when I cut and paste into Notepad WITHOUT getting those annoying quotation
marks?

 

[Guest]

Well, I'm not sure how "smart" this is... But, I got the same results you
mention in your post when I attempt to past into Notepad. I couldn't really
find a way around it.

So, if I can't fix one side... Let's try the other.

Is there any reason you have to paste into NotePad?

What I did is simply use WordPad and >PasteSpecial and chose Rich Text and I
seem to get the format you are looking for.

Just a thought...

 

[james.billy]

Guys,

3rd post on this now, and I have narrowed my problem down to this:

Function test () as String

test = "line1" & vbLf & "line2"

End

This function shows this in my Excel cell...

line1
line2

If I cut and paste it into notepad, it shows this...

"line1
line2"

I need to get rid of those quotation marks. If I take the vbLf out, i get
line1line2 and when I cut and paste there are NO quotation marks, so I know
it has to do with the fact that I put in the vbLf.

Is there ANY way I can still have my text formatted with carriage returns
when I cut and paste into Notepad WITHOUT getting those annoying quotation
marks?

Hi,

What about outputting directly to the text file rather than cutting
and pasting?

Function test() As String
Open "C:\Test.txt" For Output As #1
Print #1, "line1"
Print #1, "line2"
Close #1
End Function

This will then put in your text file:
Line1
Line2

James

 

[Guest]

I found the real cause of the problem and why it is happening.

Forget the formula. If you type line1 and the Alt-enter (to get two lines)
and then type Line2

Line1 (Alt-enter)
Line2

Now copy these two lines into Notepade you get the double quotes. Notepad
is trying to keep the two rows of data together. Don't know the solution.

 

[Guest]

Yep...it's not just notepad, Access does this also (which is where I'm really
pasting to). Is there a way when I paste into Access that I can paste into a
formatted text box or something?

 

[Guest]

unfortunately that won't help me in this scenario. Ultimately what I'm
really doing is pasting this text into an Access text box which is part of a
much larger template which auto-generates contracts for me.

 

[Guest]

why are you cutting and pasting into Access. why don't you open access witth
excel and write the data directly. or have a macro in Access that opens the
excel spreadsheet and reads the data.

This is a discussion group for programming, not for manual cut and paste.
Lets do some real programming.