View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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