Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think it's a little harsh to scold the OP because he didn't RTFM. Here's
what my help file says: Use a semicolon to position the insertion point immediately after the last character displayed. and Multiple expressions can be separated with either a space or a semicolon. A space has the same effect as a semicolon. I don't think it's at all clear that the semi-colon accomplishes what the OP asked. I recall that it took me some time to figure out how to do exactly what the OP wanted to do. I don't know about others but I think this is just one example of frequently obfuscated MS documentation. Luke "Rick Rothstein (MVP - VB)" wrote in message ... Did you try either of what Dave posted? If you look carefully at the second one, you will see a semi-colon after the Print statement argument... that tells the Print statement to suppress the line feed (actually, it is a carriage return followed by a line feed the Print added to your output and it is this combination that the semi-colon suppresses). By the way, this is covered in the help files for the Print# Statement (which I am guessing you didn't read). Rick wrote in message ... No silly. Is there a way to tell Print not to add the line feed? On Feb 18, 3:31 pm, Dave Peterson wrote: Sub Write2() Open "C:\output.txt" For Output As #1 Print #1, "hello world" Close #1 End Sub or maybe... Sub Write2() Open "C:\output.txt" For Output As #1 Print #1, "hello"; Print #1, " world"; Close #1 End Sub " wrote: I have: Sub Write2() Open "C:\output.txt" For Output As #1 Print #1, "hello" Print #1, " world" Close #1 End Sub Which creates a file that looks like hello world Is there a way to tell Print not to add the line feed - so I can get hello world Thanks. -- Dave Peterson- Hide quoted text - - Show quoted text - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
CSV line feed delimitter | Excel Programming | |||
Line Feed in Formula Bar | Excel Programming | |||
Line Feed | Excel Programming | |||
how does excel store new line and line feed characters? | Excel Programming |