QUOTE (MacNutty @ Nov 22 2008, 05:37 AM)

How to byte flip it?
To anyone who has trouble flipping the bytes, I've created a macro in a spreadsheet to do this for you.
I'm not allowed to upload this type of file so just copy and paste this code in a new excel module from the VB editor that comes with Excel. (Press Alt + F11 from within excel to do so)
CODE
Sub FlipBytes()
Dim inputSource, outputDestination
inputSource = InputBox("Enter source cell ref", "Source")
On Error GoTo exitsub
Dim varInput As String, varOutput As String
varInput = Range(inputSource).Value2
Dim bytes As Integer
Dim starter, ender
starter = 1
ender = 8
bytes = Len(varInput) / 8
Do Until bytes = 0
Dim workingstring As String
workingstring = Mid(varInput, starter, ender)
workingstring = Mid(workingstring, 7, 2) & Mid(workingstring, 5, 2) & _
Mid(workingstring, 3, 2) & Mid(workingstring, 1, 2)
varOutput = varOutput & workingstring
starter = starter + 8
ender = ender + 8
bytes = bytes - 1
Loop
outputDestination = InputBox("Enter cell ref for output", "Output")
On Error GoTo exitsub
Range(outputDestination).Value2 = varOutput
exitsub:
End Sub