Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted characters saving to fie
I have a column of digital numbers that I convert yo binaty and samv
to file "SaveBinary.bin". When I convert it back to hex, I have an extra "0D 0A" added onto the back of the file. This is an extra carriage return and linefeed the Print # Statement added. I tested it and it is not part of my data string. This is part of the Print # Statement? Is there anything I can do? Sub SaveBinary() Dim r As Range, c As Range Dim BinaryString As String BinaryString = "" Open "C:\My Documents\SaveBinary.bin" For Output As #1 <snip Print #1, BinaryString Close #1 End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted characters saving to fie
If you put a semi-colon at the end of Print or Print # statement, the
newline will be suppressed. If you are printing in a loop, you have to make sure to do this to the last line only. Change your statement to this... Print #1, BinaryString; (Note the semi-colon on the end) -- Rick (MVP - Excel) "Fan924" wrote in message ... I have a column of digital numbers that I convert yo binaty and samv to file "SaveBinary.bin". When I convert it back to hex, I have an extra "0D 0A" added onto the back of the file. This is an extra carriage return and linefeed the Print # Statement added. I tested it and it is not part of my data string. This is part of the Print # Statement? Is there anything I can do? Sub SaveBinary() Dim r As Range, c As Range Dim BinaryString As String BinaryString = "" Open "C:\My Documents\SaveBinary.bin" For Output As #1 <snip Print #1, BinaryString Close #1 End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted characters saving to fie
Thanks! Very grateful. ;)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I remove unwanted characters within a text string. | Excel Discussion (Misc queries) | |||
Removing unwanted characters | Excel Discussion (Misc queries) | |||
Removing unwanted characters | Excel Discussion (Misc queries) | |||
Removing unwanted characters | Excel Discussion (Misc queries) | |||
removing unwanted characters in a cell | Excel Programming |