 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / September 2007OK, I simplified my problem a bit, smart people sound off!!!!!
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? 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... > Guys, > [quoted text clipped - 23 lines] > when I cut and paste into Notepad WITHOUT getting those annoying quotation > marks? > Guys, > [quoted text clipped - 23 lines] > 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 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. > > Guys, > > [quoted text clipped - 41 lines] > > James 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? > I found the real cause of the problem and why it is happening. > [quoted text clipped - 52 lines] > > > > James 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. > > Guys, > > [quoted text clipped - 41 lines] > > James 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. > 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 [quoted text clipped - 45 lines] > > > > James |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.