Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print content of cells to a text file
Hi ! I developed a small macro that prints the content of some cells to a text file. I use "print" command, but I want to have, let's say , the result of 2 "print" calls on the same line...Now, on each call, it goes to a new line.. Is it possible to do that??? Or maybe using another function?? Also, if I want to echo this character: *"* , what should I use for that?? Thanks in advance, Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=485906 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print content of cells to a text file
If you put a semicolon after the string to be printed
then no newline is added: Print #1, "Don't add new line after this"; Print #1, " ... or after this"; Print #1, " but after this" Would print as a single line: Don't add new line after this ... or after this but after this To use the double-quote character in a string, you need to double it: Print #1, "Here's a double quote: "" <<< see? " Would print: Here's a double quote: " <<< see? Or you can refer to it as Chr(34) hth Andrew Taylor loopoo wrote: Hi ! I developed a small macro that prints the content of some cells to a text file. I use "print" command, but I want to have, let's say , the result of 2 "print" calls on the same line...Now, on each call, it goes to a new line.. Is it possible to do that??? Or maybe using another function?? Also, if I want to echo this character: *"* , what should I use for that?? Thanks in advance, Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=485906 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print content of cells to a text file
Thanks a lot Andrew I remembered now about printing on the same line..I used it once but it seems I forgot it Once again, Thanks Chris -- loopoo ------------------------------------------------------------------------ loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792 View this thread: http://www.excelforum.com/showthread...hreadid=485906 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a text string by reading content in multiple cells | Excel Worksheet Functions | |||
content of cell change when print file | Excel Discussion (Misc queries) | |||
How do I merge the text content of two seperate cells into one? | Excel Discussion (Misc queries) | |||
How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
How can I export cell content in Excel to a text file? | Excel Programming |