Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a variable to watch in hex?
I would like to view an array of bytes from a file stream in hex. I
saw guidance awhile back which recommends using hex(varname), but this only seems to work one byte at a time. Does anyone know how to tell the watch window to display all info for a variable in hex? Thanks in advance. Dave Smith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a variable to watch in hex?
You could open the file as binary and read it bytewise, using hex() on each
byte; e.g. Open FilePath for Binary Read as #1 Otherwise, as far as I know, there is no built-in functionality for conversion of arbitrary data types to their hex components. You would probably need to parse and convert it yourself; i.e. find out how the variable type is constructed and then break it down into its component bytes, store each in a Byte variable, and then you could convert to hex(). -- - K Dales "Dave" wrote: I would like to view an array of bytes from a file stream in hex. I saw guidance awhile back which recommends using hex(varname), but this only seems to work one byte at a time. Does anyone know how to tell the watch window to display all info for a variable in hex? Thanks in advance. Dave Smith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a variable to watch in hex?
Thanks K. As I re-read my post, I recognize my question wasn't clear
(the downside of doing anything at 6:20am) :-) I actually have the file read in to an array already, I just want to view the array in hex. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Watch | Excel Discussion (Misc queries) | |||
what does watch do? | Excel Discussion (Misc queries) | |||
VBA Watch Window | Excel Discussion (Misc queries) | |||
How do I watch a variable change value during Visual Basic Code e. | Excel Programming | |||
How do I run a Macro, but not watch it run? | Excel Programming |