Results 1 to 14 of 14

VBA calculate checksum xor of string

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2020
    Location
    france
    MS-Off Ver
    7
    Posts
    11

    VBA calculate checksum xor of string

    Hello everybody,

    Let me first wish you all the best and every success for 2021. Here is my problem.

    Given an alphanumeric string, whatever length of said string, say 1 up to X<20 characters, whatever number of strings in a selected excel spreadsheet column, I need to :

    1. calculate the checksum xor of each string, based on ascii value of each character of the string,
    2. convert xor calculated checksum value into hexadecimal, making sure that the hex checksum is a 2-digit string : if the hex conversion returns only one digit hex checksum, add a zero ("0") before the cheksum value),
    3. concatenate said hex 2-digit checksum with the corresponding string in some adjacent column.

    I have used scadacore checksum online calculator to obtain the correct ascii based xor values.

    Anyway I am grateful for any feedback, again thank you in advance for your advices.

    BR
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate CCITT 16-bit checksum from string
    By hubertmettwurst in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-07-2022, 12:48 AM
  2. [SOLVED] Calculate CRC32 checksum :)
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2016, 11:22 AM
  3. [SOLVED] One Digit Checksum
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-27-2014, 09:45 PM
  4. Generate MD5 Checksum
    By vibs_us in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2008, 02:25 PM
  5. Table Checksum
    By astrikor in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2008, 10:11 AM
  6. [SOLVED] Calculate Checksum
    By Safi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2006, 09:40 AM
  7. [SOLVED] Calculate Checksum
    By Safi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2006, 03:40 AM

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