View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
 
Posts: 238
Default 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