Results 1 to 29 of 29

macro import file hex in excel

Threaded View

  1. #7
    Registered User
    Join Date
    01-19-2012
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: macro import file hex in excel

    Quote Originally Posted by snb View Post
    Not too complicated; reading as HEX file, converting to ascii

    sub snb()
      Open "E:\file.bin" For Binary As #1
       c00 = Input(LOF(1), #1)
      Close #1
    
      redim sn(len(c00)+1)
    
      For j = 1 To len(c00) 
        sn(j) = Asc(Mid(c00, j, 1))
      Next
    
      cells(1)=join(sn,"")
    End sub
    TANKS for macro but I try a macro that displays the values ​​of excel a BIN file in hex, sorted as if it were an editor and divided by single byte.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1