BMP to XYscatter chart: How can I put a hexadecimal dump in a textfile/spreadsheet?

I am working on a macro to convert small bitmap files into Excel
xy-scatter charts, by using the markers as if they were pixels, for a
lithograph type effect. In order to do this I need to put the
hexadecimal code into cells in the spreadsheet. There is one very
basic programming task I don't know how to do: get a hexadecimal dump
into a text file. (From there, it's not too hard to format the
"hexadecimal dump" text into short lines with a word wrap in WordPad,
and then copy it into cells on the Excel spreadsheet, and then "parse"
it to do what I need it to do.)

There's probably a very simple DOS command or freeware utility that
puts a hexadecimal dump of a binary file into a text file or the
clipboard: does anyone know what it might be?

Thanks very much.

Try Hex Editor from HHD Software (free):

http://www.hhdsoftware.com/hexeditor.html

You can view a file in hex, and then copy/paste the hex digits to a text
file.

I'll be interested to hear if you have any success treating data markers as
pixels.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

"rhmd" <rh4170056@juno.com> wrote in message
news:616fccba.0307030649.45de2936@posting.google.com...
> I am working on a macro to convert small bitmap files into Excel
> xy-scatter charts, by using the markers as if they were pixels, for a
> lithograph type effect. In order to do this I need to put the
> hexadecimal code into cells in the spreadsheet. There is one very
> basic programming task I don't know how to do: get a hexadecimal dump
> into a text file. (From there, it's not too hard to format the
> "hexadecimal dump" text into short lines with a word wrap in WordPad,
> and then copy it into cells on the Excel spreadsheet, and then "parse"
> it to do what I need it to do.)
>
> There's probably a very simple DOS command or freeware utility that
> puts a hexadecimal dump of a binary file into a text file or the
> clipboard: does anyone know what it might be?
>
> Thanks very much.

Hi rhmd,

You might find the BMP routines in the examples useful.

(http://andypope.info/fun/bmpconvert.htm)

rhmd wrote:
> I am working on a macro to convert small bitmap files into Excel
> xy-scatter charts, by using the markers as if they were pixels, for a
> lithograph type effect. In order to do this I need to put the
> hexadecimal code into cells in the spreadsheet. There is one very
> basic programming task I don't know how to do: get a hexadecimal dump
> into a text file. (From there, it's not too hard to format the
> "hexadecimal dump" text into short lines with a word wrap in WordPad,
> and then copy it into cells on the Excel spreadsheet, and then "parse"
> it to do what I need it to do.)
>
> There's probably a very simple DOS command or freeware utility that
> puts a hexadecimal dump of a binary file into a text file or the
> clipboard: does anyone know what it might be?
>
> Thanks very much.

--

Cheers
Andy

http://www.andypope.info